OraFAQ Forum: SQL & PL/SQL » Reference problems

Home » SQL & PL/SQL » SQL & PL/SQL » Reference problems

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reference problems [message #36651]

Mon, 10 December 2001 06:55

Chad Larsen
Messages: 3
Registered: December 2001

Junior Member

ok so while creating a table with:
column NUMBER(38) REFERENCES db.table(column)
I am getting the error:
ORA-00942: table or view does not exist

but I can select from the referenced db.table ???

any help is much appreciated.

Thanks

--Chad

----------------------------------------------------------------------

Report message to a moderator

Re: Reference problems [message #36653 is a reply to message #36651]

Mon, 10 December 2001 08:30

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

why you are converting hd parameter to date inside function,its already date.

sql_statement :=' SELECT * from emp where hiredate < '||''''||hd||'''';

----------------------------------------------------------------------

Report message to a moderator

Re: Reference problems [message #36655 is a reply to message #36651]

Mon, 10 December 2001 08:32

hsc
Messages: 1
Registered: December 2001

Junior Member

As far as I know, u cannot specify db name the way u r doing in ur references clause. It ought to be like .. REFERENCES schema.table(column).
Replace db with schema and try.

----------------------------------------------------------------------

Report message to a moderator

Re: Reference problems [message #36660 is a reply to message #36655]

Mon, 10 December 2001 10:45

Chad Larsen
Messages: 3
Registered: December 2001

Junior Member

Actually I am using the schema.table(column) format .. apologies for the confusion. But still no love :(

----------------------------------------------------------------------

Report message to a moderator

Re: Reference problems [message #36670 is a reply to message #36655]

Tue, 11 December 2001 04:23

Chad Larsen
Messages: 3
Registered: December 2001

Junior Member

Fantastic .. that solved it .. THANK *YOU* :)

----------------------------------------------------------------------

Report message to a moderator

Previous Topic:	Regarding Ref Cursor
Next Topic:	About database login system trigger

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 31 05:36:55 CDT 2025