First, do a SHOW ERROR after you compile to see what/where the error is.
You can't issue DDL in a procedure. Look at using dynamic sql instead,
eg. -
EXECUTE IMMEDIATE 'Drop Table PRIMUS_TEMP_DUMP';
HTH,
Beth
-Original Message-
Sent: Monday, January 28, 2002 1:45 PM
To: Multiple rec
You can't run a DDL in a procedure directly, you have to use dynamic_sql to
execute DDL statements.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't r
I am trying to create the following procedure but getting the error
"compiled with errors" Can anyone tell me why?
Thanks In advance
CREATE OR REPLACE PROCEDURE Primus_Report
as
Begin
Drop Table PRIMUS_TEMP_DUMP;
CREATE TABLE PRIMUS_TEMP_DUMP (
SOLUTION_ID VARCHAR2 (85) NOT NUL
l;
>
> Rick
>
>
>
> Roland.Skoldb
> [EMAIL PROTECTED] To: Multiple recipients of
> list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> root@fatcity.
To: Multiple
> recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent by: cc:
> root@fatcity.Subject: Ang: Re:
> PL/SQL procedure - error
> com
>
>
> 01/22/
Sent by: cc:
root@fatcity.Subject: Ang: Re: PL/SQL procedure - error
com
01/22/2002
09:15 AM
Please
respond to
ORACLE-L
Thanks,
a
ct: Ang: Re: PL/SQL procedure -
error
Thanks,
and can you please tell me how to get hold of the time when the procedures starts and
finishes.?
Thanks in advance.
Roland
"Pullikol Kumar" <[EMAIL PROTECTED]>@fatcity.com den 2002-01-22 04:40 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple r
hi Roland
Hope below code will help u,
BEGIN
p1;
p2;
p3;
p4;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;
procedure p1
is
BEGIN
insert into aa values (1,'1');
END;
procedure p2
is
BEGIN
insert into aa values (2,'2');
END;
procedure p3
is
BEGIN
insert into aa v
Hallo,
anyone who can help me with a pl/sql procedure that
I have four procedures that will run one after one:
in an error table logs the procedurename, the start time of the procedure and the end
time of the procedure.the number of rows inserted(there are insertstatements in the
procedures),
ehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Lance Prais [SMTP:[EMAIL PROTECTED]]
> Sent: Wed, January 16, 2002 11:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: procedure error
>
> Why in toad when I try to create a stor
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: procedure error
RACLE-LSubject:
procedure error
Why in toad when I try to create a stored proc where I drop and
create a table I get the following error:
PLS-00103: Encountered the symbol "DROP" when expecting one of the
following:
begin function package p
ision"
=
"Lance Prais" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
17/01/2002 07:35 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Fax to:
Subject: procedure e
You
need to use 'Dynamic SQL' in order to drop and create
tables.
-Original Message-From: Lance Prais
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 16, 2002
4:36 PMTo: Multiple recipients of list ORACLE-LSubject:
procedure error
Why in toad
Why in toad when I try to create a stored proc where I drop and create
a table I get the following error:
PLS-00103: Encountered the symbol "DROP" when expecting one of the
following:
begin function package pragma procedure subtype type
use cur
Here i
A slight correction, the pragma is part of the package specification which contains
the function.
For example
CREATE OR REPLACE PACKAGE REMEDY IS
FUNCTION SLAC_DATE(ELAPSED_SECONDS IN NUMBER) RETURN DATE ;
PRAGMA RESTRICT_REFERENCES(SLAC_DATE,WNDS, RNDS, TRUST);
END REMEDY;
/
The "TR
Can you summarize how you'd use that? I'm not familiar. Thanks.
> -Original Message-
> From: MacGregor, Ian A. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 11:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: procedure error
>
You need in the stored procedure this stmt:
pragma restrict_references (, WNDS
[, WNPS] [, RNDS] [, RNPS]);
where:
WNDS means "writes no database state" (does not modify
database tables)
WNPS means "writes no package state" (does not change
the values of
packaged variables)
RNDS means "reads
610-574-7706
Pager: 877-239-4003
> -Original Message-
> From: Steve Sapovits [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 6:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: procedure error
>
>
> I have a DB instance (B) that
-4003
> -Original Message-
> From: Steve Sapovits [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 19, 2001 6:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: procedure error
>
>
> I have a DB instance (B) that's a snapshot of another (A).
>
I have a DB instance (B) that's a snapshot of another (A).
Taking a stored procedure that runs fine on A to B as part of a
query (a function really I guess?) produces this error:
DBD::Oracle::db prepare failed: ORA-06571: Function GET_EVENT does not
guarantee not to update database
Any idea
CLE-L
> Subject: procedure error
>
> Dear Gurus.
> I created a procedure and this procedure takes parameters and then makes
> and alter table DDL on the database.
> But when I write
> exec pp(table_name1,field,table_name2);
> Gives error.
> ERROR at line 1:
> ORA-0655
Dear Gurus.
I created a procedure and this procedure takes
parameters and then makes and alter table DDL on the database.
But when I write
exec
pp(table_name1,field,table_name2);
Gives error.
ERROR at line 1:ORA-06550: line 1, column
10:PLS-00357: Table,View Or Sequence reference 'K_CT_IST_K
24 matches
Mail list logo