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;
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

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


Current Time: Sat Dec 10 14:41:31 CST 2016

Total time taken to generate the page: 0.04457 seconds