devxlogo

OPO and stored procedure parameters

OPO and stored procedure parameters

Question:
Stored procedure on WG7.3 Oracle expects three parameters. I can get OPO 2.0 to pass the params if I cite them literally as, for example, exec sql begin addnewperson(‘John’,’Quincy’,’Doe’); end;.

I’d like to pass the params as variables obtained from text field values, but cannot come up with the correct way to pass single-quote enclosed params to the stored procedure. Any ideas?

Answer:
One of the limitations of the EXEC SQL command is that you can onlyuse bind variables to receive data, or in the WHERE clause of a SQL statement.

Your best bet is to parse the appropriate string and use that as theEXEC SQL command string. It’s only one more line of code, and itwill work.

devx-admin

Share the Post: