[thelist] coldfusion and stored procedures
sarah
disaster7 at yahoo.com
Wed May 30 10:52:22 CDT 2001
Without the @'s I get this error:
ORA-06550: line 1, column 7: PLS-00201: identifier
'INS_SYSTEM' must be declared ORA-06550: line 1,
column 7: PL/SQL: Statement ignored
With the @'s, I get this error:
ORA-06550: line 1, column 19: PLS-00103: Encountered
the symbol "@" when expecting one of the following: (
) - + mod not null others table avg count current
exists max min prior sql stddev sum variance execute
multiset the both leading trailing forall year month
DAY_ HOUR_ MINUTE_ second TIMEZONE_HOUR_
TIMEZONE_MINUTE_ time timestamp interval date
I assume it's working "more" with the @'s, but its
hanging on something else I'm still not doing
something right? I spose I should find out the exact
way the sp is working from the dba.
Thanks,
Sarah
--- Joshua OIson <joshua at alphashop.net> wrote:
> Sarah, based on your code, nothing glares out to me
> as incorrect. One
> point, though, is you may need to check the
> dbvarname. Depending on how the
> sp is coded, you may need to preface each with an @,
> thus turning
>
> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
> dbvarname="colo_site_network_id"
> value="#form.colo_site_network_id#"
> null="No">
>
> into
>
> <cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
> dbvarname="@colo_site_network_id"
> value="#form.colo_site_network_id#"
> null="No">
>
> What sort of error is this giving, if any?
>
> -joshua
>
> ----- Original Message -----
> From: "sarah" <disaster7 at yahoo.com>
> To: <thelist at lists.evolt.org>
> Sent: Wednesday, May 30, 2001 11:13 AM
> Subject: [thelist] coldfusion and stored procedures
>
>
> : The code I'm using is at the end of this message.
> : Anyhow, the problem is. I have a form being filled
> out
> : and I need to insert the values with a stored
> : procedure. I haven't done this before and I'm
> having
>
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
More information about the thelist
mailing list