Home » Developer & Programmer » Forms » Why i'm getting this error? dblink
Why i'm getting this error? dblink [message #493993] Thu, 10 February 2011 14:15 Go to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
Why i'm getting this error? dblink
SQL> desc Worksh@PASS;
 Name                   Null?          Type
 --------------------- --------   --------------------
 PLId                  NOT NULL       CHAR(15)
 LineID                NOT NULL       NUMBER(10)
 ScreenLineId          FLOAT(49)
 Location              VARCHAR2(10)

SQL> select * from Worksh@PASS where  PLId = '00000CB00000000';
select * from Worksh@PASS where  PLId = '00000CB00000000'
                                           *
ERROR at line 1:
ORA-00904: "PLBCID": invalid identifier

Re: Why i'm getting this error? dblink [message #493997 is a reply to message #493993] Thu, 10 February 2011 14:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because "PLId" is not PLId. The latter is same as "PLID".

=> Do NOT use lower case in object names.

Regards
Michel
Re: Why i'm getting this error? dblink [message #493998 is a reply to message #493997] Thu, 10 February 2011 14:50 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Someone is not telling the truth - it is either you, or Oracle.

Table description suggests that column name is
PLId
and you use it in a query.

Error says that
PLBCID
is an invalid identifier.

So, what is the truth? Would you mind posting your SQL*Plus session, a real one?

As Michel said - if you really created a table whose column names are in mixed case (not a good idea in Oracle world), you'll have to enclose those column names into double quotes every time you use them.
Re: Why i'm getting this error? dblink [message #493999 is a reply to message #493998] Thu, 10 February 2011 15:05 Go to previous message
piyarustagi
Messages: 38
Registered: January 2011
Member
PLBCID is my typing mistake... sorry...it's PLId.
But, you are right.... "enclose those column names into double quotes"..
Thanks a lot.
Previous Topic: HTTPS in Oracle forms (merged 5)
Next Topic: Forms hanging when trying to commit or update
Goto Forum:
  


Current Time: Mon Sep 16 13:04:55 CDT 2024