ODBCOutput with select statement
Posted: Fri Mar 06, 2020 3:13 pm
I've used ODBCOutput to do dml and ddl on oracle tables but is this possible?
ODBCOutput(vConnection, 'select 12345 into %vNumber% from dual');
The reason is I'd like to use this as like a post-query against a sql based ODBC data source in a process. I've read all over the place and seen numerous instances for insert, update, delete. I've done commits and truncates as well. The select works without the into clause. Is there a way to make the into clause work?
As written it doesn't compile with variable not defined error. If I define the variable and put the query into the expand function it parses the variable to a literal.
ODBCOutput(vConnection, 'select 12345 into %vNumber% from dual');
The reason is I'd like to use this as like a post-query against a sql based ODBC data source in a process. I've read all over the place and seen numerous instances for insert, update, delete. I've done commits and truncates as well. The select works without the into clause. Is there a way to make the into clause work?
As written it doesn't compile with variable not defined error. If I define the variable and put the query into the expand function it parses the variable to a literal.