Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to create flexable package
Message
 
 
À
23/09/2004 14:08:09
Information générale
Forum:
Oracle
Catégorie:
Paquets
Divers
Thread ID:
00940366
Message ID:
00945470
Vues:
30
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform