fgimenes
Occasional Contributor
Joined 3 years ago
User Profile
User Widgets
Contributions
Not able to call an Oracle Procedure and perform a SQL statement right after
I need to interact with a table which is under a Oracle VPD policy(Virtual Private Database), so I need to run a Procedure first, which runs fine from JDBC Test Step. I am calling like: {call dbms_application_info.set_client_info('SYSTEM_DDL')} But I need to run a SQL Statement right after this: SELECT count (1) FROM CLIENTSERVICESSCHEMA.Account So the whole code is: {call dbms_application_info.set_client_info('SYSTEM_DDL')} SELECT count (1) FROM CLIENTSERVICESSCHEMA.Account I am getting the following error: 2022-09-09 12:35:32.156 - Error getting response; java.sql.SQLException: ORA-06550: line 3, column 1: PLS-00103: Encountered the symbol "SELECT" ORA-06550: line 5, column 0: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: . , @ ; for <an identifier> <a double-quoted delimited-identifier> group having intersect minus order partition start subpartition union where connect sample Having the call to the procedure in one test step and then the Select statement in another test step does not work. I've tried so many things, I ran out of ideas. Does anyone have any idea how to do this? Thank you!Query doesn't return records in JDBC Test Step, but works fine in Oracle SQl Editor
Hi, I am trying to run this query in JDBC Test Step: SELECT ACCOUNT.ID FROM PERSON JOIN CLIENT on PERSON.ID = client.person_id JOIN CLIENTACCOUNTMAP on client.id = CLIENTACCOUNTMAP.CLIENT_ID JOIN ACCOUNT on ACCOUNT.id = clientaccountmap.account_id WHERE mobilephone = '0468 600 391' But t doesn't return any record. But when I run from Oracle directly, records are returned just fine: Does anyone have any idea? Thanks
