Home » Developer & Programmer » Forms » How to pass parameter to databse package
How to pass parameter to databse package [message #239634] Tue, 22 May 2007 21:05 Go to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member
I have created a simple database package. The problem is I don't know how to pass a parameter from form to package.
for example, in this package I want to give value to p_date from forms.

CREATE OR REPLACE PACKAGE Pkg_1 IS
Date_Value DATE
PROCEDURE Get_Date(p_date IN DATE);
FUNCTION xdate RETURN date;
END;

Report message to a moderator

Re: How to pass parameter to databse package [message #240303 is a reply to message #239634] Thu, 24 May 2007 10:19 Go to previous message
NizamUlMulk
Messages: 11
Registered: May 2007
Location: Paraguay
Junior Member
Example:
declare
v_date date;
begin
v_date := Pkg_1.xdate; -- calling function
Pkg_1.Get_Date(v_date); -- calling procedure
-- or nested without params
Pkg_1.Get_Date(Pk1.xdate); -- but this package doesn´t return anything

Report message to a moderator

Previous Topic: problem in imgscan.ocx
Next Topic: sql server connect with oracle forms 6i
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:15:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.