on 04-26-2005 10:23 PM
In using a stored procedure, has anyone returned either a cursor back or a record structure?
An Oracle example would look like the following:
PROCEDURE qryEmployee(pUserID IN varchar2, pEmployee out t_cursor)
IS v_cursor t_cursor;
Begin
open v_cursor for
Select e.user_id, e.emp_name, e.functional_group_id
from TOTS_EMPLOYEE e
where e.user_id = pUserID;
pEmployee := v_cursor;
Exception
when NO_DATA_FOUND then
null;
when OTHERS then
raise;
End qryEmployee;
The idea is to return a curosr that has records attached and have XI map it out to an XI response.
It would be called within XI as follows:
<MT_Employee_Procedure>
<root>
<qryEmployee action="EXECUTE">
<table>TOTS_PROCEDURES.qryEmployee</table>
<pUserID isInput="true" type="VARCHAR">baudaisk</pUserID>
<pEmployee isOutput="true" type="CURSOR"></pEmployee>
</qryEmployee>
</root>
</MT_Employee_Procedure>
As far as I know the type CURSOR is not supported in XI. Is there a way of returning cursor information using stored procedures?
Hi,
There is no cursor support in XI. Similar to a table-select, the store procedure will return a resultset.
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See own Message
Message was edited by: Mark Newman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.