OraFAQ Forum: Forms » add lexical and Bind variable to RUN

Home » Developer & Programmer » Forms » add lexical and Bind variable to RUN_PRODUCT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add lexical and Bind variable to RUN_PRODUCT [message #82840]

Tue, 08 July 2003 14:17

Mutindan
Messages: 5
Registered: July 2003

Junior Member

Hi all,
I have the following RUN_PRODUCT function

DECLARE
pl_id ParamList;
BEGIN
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'CATEGORY',TEXT_PARAMETER,(:CATEGORY));
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'Screen');
Run_Product(REPORTS, 'C:Pled', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
Destroy_Parameter_List( pl_id );
END;

How can I define both Lexical and Bind variable within it. I have tried to
method shown below for bind variable (:CATEGORY)but it gives me "bad bind
variable error"

Thanks all!!

Report message to a moderator

Re: add lexical and Bind variable to RUN_PRODUCT [message #82846 is a reply to message #82840]

Wed, 09 July 2003 01:43

sujit
Messages: 94
Registered: April 2002

Member

hi,
from where you are taking this :CATEGORY ? simply it is not defined in your form. SO make sure of what you are doing. i think your code is fine.

Sujit

Report message to a moderator

Re: add lexical and Bind variable to RUN_PRODUCT [message #82853 is a reply to message #82846]

Wed, 09 July 2003 08:15

Mutindan
Messages: 5
Registered: July 2003

Junior Member

Thanks Sujit,
This is how I have it.
I have a report PLED with a bind variable :CATEGORY.

I wanted to call this report form a form and let users enter a value.

Report message to a moderator

Re: add lexical and Bind variable to RUN_PRODUCT [message #82854 is a reply to message #82853]

Wed, 09 July 2003 11:34

Julie
Messages: 98
Registered: February 2002

Member

Change paramform to yes, to show your users the parameter form to enter a value for :category.

Report message to a moderator

Re: add lexical and Bind variable to RUN_PRODUCT [message #82894 is a reply to message #82853]

Tue, 15 July 2003 03:55

rama krishna
Messages: 97
Registered: December 2001

Member

the :category u r specifying shd be on form
the second parameter is name of bind parameter present in report and the 4th parameter is the value u need to assign to the bind parameter in report..if category field is not present on form it will give u an error, so mention a value which u want to assign to category in report instead of :category

cheers
ram

Report message to a moderator

Previous Topic:	check box selection in data base block
Next Topic:	PICK_LIST PACKAGE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 08:18:17 CDT 2024