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: