Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to create flexable package
Message
From
23/09/2004 14:08:09
 
General information
Forum:
Oracle
Category:
Packages
Miscellaneous
Thread ID:
00940366
Message ID:
00945462
Views:
29
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform