In message <1161813277.510596.165330_at_i42g2000cwa.googlegroups.com>,
samthegreat_at_gmail.com writes
>Hi everybody,
>
>
>I am able to use this function successfully on the MYDB_PROD db using a
>select like
>
>select ROW_ID
> ,LONG_TO_VCHAR2_O(ROW_ID)
>from S_NOTE_OPTY_at_MYDB_PROD
>WHERE row_id = '1-B49RRX'
>
>However, when I try to run the exact same select statement on MYDB_DW I
>get ORA-00904 "LONG_TO_VCHAR_O": invalid identifier.
>
>This message seems to indicate that I'm trying to select a column that
>doesn't exist.
>
>Please send your wisdom in my general direction!
>
>Thanks in advance.
>
>- Sam
>
Is the definition of the dblink mydb_prod the same on both databases?
Can you call the function directly from a plsql block?
--
Jim Smith
I'm afraid you've mistaken me for someone who gives a damn.
Received on Thu Oct 26 2006 - 03:19:33 CDT
