Help in oracle procedure

[chella]

Hi,

Please help me in debugging the below procedure.

SQL> create or replace procedure pr_test_new
2 as
3 declare sql_stmt varchar2(100);
4 begin
5 sql_stmt:='sele ct * from price';
6 execute immediate sql_stmt;
7 end;
8 /

I am using oracle 8i

While creating this procedure I get the following warnings.

Warning: Procedure created with compilation errors.

LINE/COL ERROR
-------- -----------------------------------------------------------------
5/9 PLS-00103: Encountered the symbol "=" when expecting one of the
following:
constant exception <an identifier>
<a double-quoted delimited-identifier> table LONG_ double ref
char binary national character nchar
The symbol "<an identifier>" was substituted for "=" to continue.


6/19 PLS-00103: Encountered the symbol "SQL_STMT" when expecting one
of the following:
:= . ( @ % ; not null range renames default character


Please help me in solving the above problem.

Thanks in advance,
Chella

[chella]

The problem is its not taking as EXECUTE IMMEDIATE.

Instead, it is taking just EXECUTE command which is basically used to execute any procedure,funct ions etc.

Eg: Both are same:

EXECUTE proc1(a,b,c);
EXEC proc1(a,b,c);

I hope the problem is with my server.

Thank You vary much for the replies.

Regards,
Chella

[amitpatel66]

I hope the problem is with my server.

Thank You vary much for the replies.

Regards,
Chella

You are Welcome :)

Regards,
Amit