Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How To create TNSNAMES.ORA where server has 2 LAN Cards install

535287Sep 22 2006 — edited Mar 27 2007
Dear Friends,

I have a problem to connect node with server.

Server configuration :
OS --> Window XP is install
LAN Card --> 1 regular card
Other Card --> Ethernet Card for inter net.

Client configuration :
OS --> Window 98

On the server , i can connect oracle at server with regular TCP/IP protocol. But at node i m not able to connect oracle. IT IS GIVING ERROR TNS-ERROR not able to connect.

Please give me your valuable suggetions.
Email : komalkshah@yahoo.com

Comments

Answer

rqEval can accept non-numeric types as input.

In your example, 'select 1 "Industry" forces a returned numeric value.  It fails because the data returned contains 1 non-numeric column. The output doesn't match the specification in the SQL provided, and an error is returned.

Instead, use cast to return as varchar as follows:

SQL> select * from table(rqEval(

        NULL,

        'select cast(''Industry'' as varchar2(8)) "Industry" from dual',

       'Test'));

Returns:

1 Text

Marked as Answer by 3631507 · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 24 2007
Added on Sep 22 2006
1 comment
8,507 views