How can we execute an procedure without an output variable?
Article ID: KB0072308
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
If we are trying to execute a procedure without any output variable such as setEnvironment() which only takes input (environment variable) and performs certain tasks using them.
executing using the standard command: exec setEnvironment 'Test','Value';
TDV returns an error:
Error: An exception occurred when executing the following query: "exec SetEnvironment 'Test','Value'". Cause: Procedure '/services/databases/SetEnvironment' must contain only one output cursor with unique fields or at least one scalar output.
On line 0, column 0. [parser-2906438] [Log ID: f4f8191c-2ef8-4181-b5b8-79a33c8f45ff] [jdbc-1906510] SQLState: ErrorCode: 1906510
To resolve this below mentioned steps will be helpful.
Environment
Windows, Linux, macOS
Resolution
We can use the below syntax to call the procedure without any output variable from TDV or any 3rd party JDBC DB tools such as DBeaver or DBvisualizer.
{call "Procedure_name"('<input1>','<input2>')};
E.g.: {call "SetEnvironment"('SpotfireUser','value')};
{call "Procedure_name"('<input1>','<input2>')};
E.g.: {call "SetEnvironment"('SpotfireUser','value')};
Issue/Introduction
How can we execute an procedure without an output variable.
Additional Information
Feedback
Yes
No
Powered by
