How can I include promptset values in VARA.SQLI/VARA.SEC.SQLI object?

[NARASIMHA GUDI]

Hello All,

I've been trying to include values from a promptset (timestamp) in a VARA.SEC.SQLI object. However, the Bind parameter isn't working and I'm getting the error mentioned below:

U00029106 UCUDB: The number of bind parameters does not match. Expected '1', actual '0'.

Please advise..

Thanks in advance!

[Legacy User]

Hi Narasimha!

I would recommend opening a case with Support to provide us additional details. I've done some quick testing and determined we would need to look at your configuration to help troubleshoot that error message. Apologies we weren't able to provide a quicker answer via Community!

[Anon Anon]

Hi

there seems to be a dependence WHERE the bind parameter is placed.

For example - working:
select EH_NAME , EH_OTYPE, EH_STATUS , EH_STARTTIME from EH
where EH_CLIENT = ?

NOT working:
select EH_NAME , ?, EH_STATUS , EH_STARTTIME from EH
where EH_CLIENT = &$CLIENT#

Database-error in SQLI-variable: 'U00003590 UCUDB - DB error:
'OCIStmtExecute', 'ERROR   ', '', 'ORA-00911: invalid character''

so which SQL select do you want to execute?

cheers, Wolfgang

[NARASIMHA GUDI]

Hello Wolfgang, Thanks for your answer. However, I have doubt with the query.
I'm actually trying pull certain data from Automic DB with a particular time frame. I want the time frame to be dynamic. Hence, using Promptset to take the values from the user. Now, I'm trying to include the input from the promptset to VARA.SQLI or VARA.SEC.SQLI. Please refer to the screenshot.

[Anon Anon]

Hi

as I see from the screenshot, you should include a Key when using the curly brackets notation - usually {VARAOBJECT,KEY,[optional: column]}

cheers, Wolfgang

[Anon Anon]

One more finding: Field EH_IDNR des not exist in Db - its called EH_AH_IDNR :-)

here is a working example for a VARA.SQLI object:

select EH_NAME , EH_AH_IDNR, EH_STATUS , EH_STARTTIME, EH_HOSTdst from EH
where eh_starttime <= to_date('&$PHYS_DATE_YYYY_MM_DD_d# &$PHYS_TIME_HH_MM_SS#','YYYY-MM-DD HH24:MI:SS')
and EH_STATUS = 1900
and EH_CLIENT = &$CLIENT#

cheers, Wolfgang

[Legacy User]

Thanks for the assistance Wolfgang! I was under the impression Narasimha was attempting to pull values directly from a promptset into the VARA.SEC.SQLI variable but I see from the screenshot the data is pulling simply from another VARA object. I'll continue to check on this thread if there is anything additional I can assist with :)