Jump to content


Joseph Serra

Member Since 31 Jan 2000
Offline Last Active Oct 29 2008 05:50 AM
-----

Posts I've Made

In Topic: Oracle Synonyms

26 June 2007 - 01:02 AM

Woohoo!!! (w00t) It works!!!

I don't know what I was doing wrong, but I tried it today and it just works.

I was getting 'ORA-00942: table or view does not exist'. But I have just created a public synonym and created a ProIV logical file def, and then a function to use it, and it works.

Thanks for you help, everyone...

Joseph

In Topic: Oracle Synonyms

26 June 2007 - 12:00 AM

Wayne!!! Hiya mate...

Thanks for the reply. I created both, public and private. And I fiddled with the grants too.

I then spat the dummy, swore a lot and gave up...

Anyway, thanks for the help, I shall give it another go sometime today...

See you soon buddy...


Joseph

In Topic: Oracle Synonyms

25 June 2007 - 11:55 PM

Hi Rob

Thanks for the reply. I did do a search, but all I found was synonyms created on the fly and then referenced in embedded SQL.

I was more interested in Synonyms mapped to a ProIV file definition. But from what I gather, it is possible, I'm just having a blond moment...

Joseph

In Topic: Oracle Synonyms

22 June 2007 - 06:59 AM

Thanks for your help Jeff.

I think it might have something to do with Friday afternoon. I think I will give up on this today and tackle on monday morning.

In Topic: Oracle Synonyms

22 June 2007 - 06:40 AM

Weird, that gives me an error saying 'table or view does not exist'...

But I can do a "select * from <synonym name>".

Do you specifically create public synonyms?