Calling Oracle Store Proc Thru PB
Posted on 2004-04-16
1. I want to call Oracle Stored Procedure thru my PB application. Can you please tell me how i can do this?
I am using PB 8.0.1 with Oracle 8.1.7. I want to call a store proc that will either return a single value or a result set. What is the way to call both kind of store procs from PB. I tried using the RPCFUN method but i coulden't get the result.
Can i directly attach the store proc returning resultset to the datawindow? If yes then how can i change the output of a datawindow dynamically based on the input parameter?
What is the purpose of DataWindow.Modify() method?
Can i attach the store proc returning single value to a textbox or other control?
What are different ways for all this?
2. Also tell me how to access a value returned thru an OUT parameter from a store proc.
Ex: if i have a store proc in oracle as:
procedure showname(empno IN number, ename OUT varchar2) i.e. i am getting the name of the employee from emp table by entering the empno.
Now when i call this store proc from PB, i want to display this name into a textbox when i click on a button. How can i get the returned name value from the procedure?