Home » RDBMS Server » Server Administration » Strange circumstance with Oracle Error Code 604: Please Help
Strange circumstance with Oracle Error Code 604: Please Help [message #370823] Fri, 11 February 2000 10:42 Go to next message
gpy
Messages: 1
Registered: February 2000
Junior Member
We have been using a Cold Fusion app to allow users to create their own accounts. This is the statement which is being passed to Oracle:

create user #Trim(FORM>txtUsername)#
identified by "randompassword"
default tablespace usr_1 temporary tablespace temp_3;

It sometimes raises this error:
ORA-00604: error occured at recursive SQL level ORA-1801: date format is too long for internal buffer.

WHAT GIVES? There is no date processing in the statement at all?

Report message to a moderator

Re: Strange circumstance with Oracle Error Code 604: Please Help [message #370871 is a reply to message #370823] Mon, 28 February 2000 12:57 Go to previous message
Naveen Kumar V
Messages: 16
Registered: February 2000
Junior Member
use this
create user "Trim(FORM>txtUsername)"
identified by naveen
default tablespace usr_1 temporary tablespace temp_3;

and u should connect as "Trim(FORM>txtUsername)"

I don't know whether it may answer you question.

Report message to a moderator

Previous Topic: Terminal in ORACLE
Next Topic: DBMS_SQL V7 parameter error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 08 22:54:21 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.