Hi,
This is hopefully a real easy question but I want to write a simple
stored procedure to open a return ref cursor based on dynamic sql...
Basically I want to do the following - but dont know the proper
syntax!
create or replace PROCEDURE "SP_GET_TRADES"
(
accounts IN varchar2,
rs IN OUT sys_refcursor
)
IS
stmt_sql VARCHAR2(4000);
BEGIN
stmt_sql := ' SELECT * FROM trades ' ||
' WHERE p.acct_cd in (''1000'') AND a.sec_id = p.sec_id
';
EXECUTE IMMEDIATE stmt_sql INTO rs;
END Sp_Account_Trades;
Used to doing this sort of thing in SQL Server and am very new to
Oracle and am finding it very different in how datasets are
returned...
Thanks in advance.
Jeremy.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
