Stored procedures and ColdFusion
From: Judas <jsrobins_at_sghms.ac.uk>
Date: 27 Nov 2002 05:41:58 -0800
Message-ID: <dcf83d80.0211270541.44c9d89d_at_posting.google.com>
Date: 27 Nov 2002 05:41:58 -0800
Message-ID: <dcf83d80.0211270541.44c9d89d_at_posting.google.com>
I am trying to create stored procedures on an Oracle 8i database using ColdFusion. However I change the syntax, the thing doesn't seem to work. The SQL statements are:
CREATE PROCEDURE judas AS
BEGIN
null;
END;
And the error is:
PLS-00103: Encountered the symbol "" when expecting one of the following: begin function package pragma procedure subtype type use <an identifier> <a doublequoted delimited-identifier> cursor form current external language
(the procedure is invalid)
Thanks in advance for any suggestions or help.
Judas. Received on Wed Nov 27 2002 - 14:41:58 CET