Welcome to the Quest Code Tester Community
Advanced Search - Help - Search Toad World
Welcome, Guest
Login Login / Register
Help
NEW? Get Plugged In

Forums » Beta Program » General Questions and Announcements

Thread: error ORA-00911: invalid character

This question is answered.


Permlink Replies: 1 - Pages: 1 - Last Post: Nov 6, 2009 7:21 AM by: stevenfeuerstein
Svyatoslav

Posts: 1
Registered: 11/5/09
error ORA-00911: invalid character
Posted: Nov 6, 2009 4:29 AM
 
  Click to reply to this thread Reply

Hi.
(sorry for my English)

I am trying to use beta 1.9.0.460, but i have an error.
i have a procedure in a package like this:

procedure my_proc(
param1 mytable.myfield%type
)
is
begin
...
--some code here
end;


when i try to create new test for this package i receive error:

Unexpected failure when initializing test definition from program definition.

An unanticipated error has occurred. Please review the information below and see if it will help you resolve the problem.

ERROR_BACKTRACE = ORA-06512: at "SYS.DBMS_UTILITY", line 125
ORA-06512: at "LISACODETESTER.QU_ALL_OBJECTS", line 2672
ORA-06512: at "LISACODETESTER.QU_DATATYPE_XP", line 1716
ORA-06512: at "LISACODETESTER.QU_DATATYPE_XP", line 1786
ORA-06512: at "LISACODETESTER.QU_UNIT_TEST_XP", line 1351
ORA-06512: at "LISACODETESTER.QU_UNIT_TEST_XP", line 1901
ORA-06512: at "LISACODETESTER.QU_UNIT_TEST_XP", line 1946
ORA-06512: at "LISACODETESTER.QU_HARNESS_XP", line 1106

ORACLE_ERROR = ORA-00911: invalid character


i have found that if i change

procedure my_proc(
param1 mytable.myfield%type
)


by
procedure my_proc(
param1 number
)


all is ok.
i think i must grant some privilege but i dont now what to do exactly.

thanks, for your help.


stevenfeuerstein


Posts: 204
Registered: 5/18/06
Re: error ORA-00911: invalid character
Posted: Nov 6, 2009 7:21 AM   in response to: Svyatoslav
Answered
  Click to reply to this thread Reply

This error has been fixed. I will see about getting a new beta posted by early next week.

SF



Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums