Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Truncate table usage in procedure..

836881Feb 9 2011 — edited Feb 9 2011
Dears,

I created the table testing.

Now i wrote a procedure like this.

create or replace procedure trunc_test
(ov_v_output OUT VARCHAR2) IS
begin
truncate table testing;
end;

I got error message as

PLS-00103: Encountered the symbol "TABLE" when expecting one of the following:

:= . ( @ % ;

Anybody help in this regard..

Thanks & Regards,
Raja.
This post has been answered by Karthick2003 on Feb 9 2011
Jump to Answer

Comments

591186
[http://www.orafaq.com/wiki/XA_FAQ]

also. You have to execute $ORACLE_HOME/rdbms/admin/xaview.sql to have XA releated views created.

Perhaps, Metalink note : Required Grants For Retail Integration Bus Distributed XA Transaction-467466.1 Would help.


HTH
Anantha.
Timur Akhmadeev
From what I gathered, I think I need to run initjvm.sql and initxa.sql but I am not entirely sure.
Starting with JDBC driver 10g you don't have to execute initxa.sql. Basically, before 10g JDBC driver [used a PL/SQL package|http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/xadistra.htm#BGBIDIGD] named JAVA_XA to manage distributed transactions, but with 10g it doesn't require additional database configuration, since it uses native protocol (claimed to be faster) without issuing PL/SQL.
Also, what is the XA driver class called? Is that oracle.jdbc.xa.client.OracleXADatasource?
Yes.
1 person found this helpful
708336
Hi,

Thanks for the response.
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
Timur Akhmadeev
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
According to documentation - no.
1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 9 2011
Added on Feb 9 2011
4 comments
98,352 views