Home » RDBMS Server » Server Administration » calling a package
calling a package [message #50825] Tue, 09 April 2002 10:55 Go to next message
Eugene
Messages: 44
Registered: August 2001
Member
I have a package spec part of witch is cursor. I need to call this package and pass parameters into that cursor. How do I call the package? Thanks, Eugene
Here is what I have:

CREATE OR REPLACE PACKAGE PD2_PKG AS
Declaration ......
Cursor CUR_ALL_SALES IS
SELECT
....
all_sales_rec cur_all_sales%rowtype;

PROCEDURE PD2_MAIN_P;
PROCEDURE PD2_FIRST_PASS_P (all_sales_rec IN OUT cur_all_sales%rowtype);
PROCEDURE PD2_SECOND_PASS_P (all_sales_rec IN OUT cur_all_sales%rowtype);
END PD2_PKG;
/

Report message to a moderator

Re: calling a package [message #50831 is a reply to message #50825] Tue, 09 April 2002 17:37 Go to previous message
seng
Messages: 191
Registered: February 2002
Senior Member
call like
PACKAGENAME.PROCEDURE(PARAMETER);

Report message to a moderator

Previous Topic: Re: problems with rman oracle 9i
Next Topic: Can another user start the ORACLE DATABASE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 10:27:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.