Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create flexable package
Message
 
 
To
23/09/2004 14:08:09
General information
Forum:
Oracle
Category:
Packages
Miscellaneous
Thread ID:
00940366
Message ID:
00945470
Views:
31
This message has been marked as a message which has helped to the initial question of the thread.
Try it using private variables and my BEGIN/END syntax.

>Mark, we use the 'p' prefix in scoping for 'P'arameters. We never use 'Private' variables.
>
>
>* These values are just for testing.
>LOCAL lnEmpHireNo, lnTypeNo, ldCurrDate
>lnEmpHireNo = 2       && This will be the value of an OptionGroup
>lnTypeNo    = 3       && This will be the value of an OptionGroup
>ldCurrDate  = DATE()  && This will be the value of a TextBox
>
>lcSqlStatement = "{call Get_Emp_Combo_List.ReturnEmpComboList(?lnEmpHireNo, ?lnTypeNo, ?ldCurrDate)}"
>
>lnConHndl = sqlexec(lnSatHandle, lcSqlStatement, 'test_cursor')
>
>
>HTH
>Mike
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform