How can i use stored procedures in PX.
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
How can i use stored procedures in PX.
Hi All,
How can i use stored procedures (For Oracle database) in PX? I also want to pass parameters to the procedure.
-Nripendra
How can i use stored procedures (For Oracle database) in PX? I also want to pass parameters to the procedure.
-Nripendra
-
- Participant
- Posts: 64
- Joined: Fri Jul 16, 2004 7:53 am
I haven't used store procedure in my project.. This topic has been discussed already i am give that link...viewtopic.php?t=91200&highlight=Stored+Procedure
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
-
- Participant
- Posts: 64
- Joined: Fri Jul 16, 2004 7:53 am
-
- Participant
- Posts: 64
- Joined: Fri Jul 16, 2004 7:53 am
I am giving a sample Store Procedure where you pass the Country_id
Open a cursor to store all the values there..
CREATE OR REPLACE PROCEDURE <Procedure_Name>(Country_id NUMBER) IS
BEGIN
IF Country_id IS NULL THEN
Cursor Country_out is Select * from table;
Else
Cursor Country_out is Select * from table where Country_id = <Country_id>
RETURN;
END IF;
Please modify the code according to your need... Just pass the country_id as the input and verify it in the procedure...
Open a cursor to store all the values there..
CREATE OR REPLACE PROCEDURE <Procedure_Name>(Country_id NUMBER) IS
BEGIN
IF Country_id IS NULL THEN
Cursor Country_out is Select * from table;
Else
Cursor Country_out is Select * from table where Country_id = <Country_id>
RETURN;
END IF;
Please modify the code according to your need... Just pass the country_id as the input and verify it in the procedure...
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Hi,
you didn't mention if your on a 7.5 release of DS?
if so there is a new stored procedure stage that supports also output parameters.
though it seems to run via ODBC.
IHTH,
you didn't mention if your on a 7.5 release of DS?
if so there is a new stored procedure stage that supports also output parameters.
though it seems to run via ODBC.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org