| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
PL/SQL packages from ASP with JavaScript |
|
From: |
Mari Ann |
|
Date: |
10/15/1999 9:37:56 AM |
|
IP: |
4.17.250.5 |
Does anyone have experience accessing an Oracle stored package on an ASP page scripted with Javascript?
I can find examples of this done with VB, but not with JavaScript. The VB call does not work with JavaScript.
Using VB type of call:
lsSQL = "{Call MY_STORED_P.GET_TYP_CD({Resultset 100,CD_TBL,DESC_TBL,ERR_SEQ_OUT})}"
I get this error: ORA-06550: line 1, column 7: PLS-00306 wrong number or types of arguments in call to GET_TYP_CD
When I try this:
lsSQL = "{Call MY_STORED_P.GET_CD(CD_TBL,DESC_TBL,ERR_SEQ_OUT)}"
I receive this error:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 56: PLS-00201: identifier CD_TBL must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Anyone know how to do this?
Ill resort to using VB if necessary, but would rather stick with JavaScript.
Thanks.
|
|
|
|
|
|
|
