Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle 00604 error?
"Ian" <not_at_available.com.au> wrote in
news:42418432$1_1_at_news.chariot.net.au:
> hi,
> I have a problem with a pro*C apllication which fails to log me in
> I get the following error--
> ERROR:ORA-00604:error occured at recursive SQL level 1
> ORA-00911:invalid
> I am using SolarisX86 and Oracle 10g. with the following .pc code
> fragment:
>
> strcpy(uid.arr,"username");
> uid.len = strlen(uid.arr);
>
> strcpy(pwd.arr,"password");
>
> pwd.len = strlen(pwd.arr);
>
> EXEC SQL WHENEVER SQLERROR GOTO sql_error;
>
>
> EXEC SQL CONNECT :uid IDENTIFIED BY :pwd;
>
> printf("LOGGED IN\n");
>
> I don't understand what is caussing this to occur. my code is simple,
> If I substitute SYS as username with appropriate password I get told
> to login as SYSDBA.
> Also, if I type sqlplus from a window and then enter the same username
> and password from the code I CAN login OK - hence my confussion.
> I have looked through the docs but can't seem to find the cause.
> Could anyone please help as to identify why this error is ocurring,
> regards
> Ian
>
>
>
00911, 00000, "invalid character"
// *Cause: identifiers may not start with any ASCII character other than // letters and numbers. $#_ are also allowed after the first // character. Identifiers enclosed by doublequotes may contain // any character other than a doublequote. Alternative quotes // (q'#...#') cannot use spaces, tabs, or carriage returns as // delimiters. For all other contexts, consult the SQL Language // Reference Manual. // *Action:Received on Wed Mar 23 2005 - 09:31:19 CST
![]() |
![]() |