Re: [sqr-users] DB Link problem

[Kaz.Narayanan@averydennison.com]

Hi,

Ensure that the SYSADM password for the both instances are same.
Thanks
Regards
KM Narayanan




"Hlavenka, Mark" <Mark.Hlavenka@boeing.com>@sqrug.org on 08/05/2004
08:21:18 AM

Please respond to "This list is for discussion about the SQR database
       reporting  language from Hyperion Solutions." <sqr-users@sqrug.org>

Sent by:    sqr-users-bounces+kaz.narayanan=averydennison.com@sqrug.org


To:    <sqr-users@sqrug.org>
cc:

Subject:    [sqr-users] DB Link problem

I've created a database link to another database and am trying to pull
data from that database in my SQR.  My syntax is:

begin-select
a.po_id
a.resource_id
from PS_BSC_CLD_TBL@FTEST8 a
end-select

When I run this, I get the following error:
(SQR 5528) ORACLE OCIStmtExecute error 3113 in cursor 6:
   ORA-03113: end-of-file on communication channel

Error on line 328:
   (SQR 3723) Problem executing cursor.

SQR for PeopleSoft: Program Aborting.
(SQR 5528) ORACLE OCITransRollback error 3114 in cursor 0:
   ORA-03114: not connected to ORACLE
(SQR 5528) ORACLE OCITransCommit error 3114 in cursor 0:
   ORA-03114: not connected to ORACLE

I can run this select statement just fine via a SQL query tool.  Anyone
have any suggestions?

Thanks for your help.
Mark Hlavenka


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users






-----------------------------------------
The information transmitted is intended only for the person or entity
to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this
information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the
sender and delete the material from any computer.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users