ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using Oracle DESC in ESQL using PASSTHRU

Post new topic  Reply to topic
 Using Oracle DESC in ESQL using PASSTHRU « View previous topic :: View next topic » 
Author Message
mbnewbie
PostPosted: Tue Apr 19, 2016 11:36 pm    Post subject: Using Oracle DESC in ESQL using PASSTHRU Reply with quote

Novice

Joined: 04 Oct 2013
Posts: 19

Hi,
Could not find any example whether the Oracle DESC <Table Name> command can be fired from ESQL in the form - SET Environment.Data[] = PASSTHRU('DESC MYTABLE');
MB Version is 8 and Oracle is 11g.
Getting exception as invalid SQL.
Back to top
View user's profile Send private message
maurito
PostPosted: Tue Apr 19, 2016 11:45 pm    Post subject: Re: Using Oracle DESC in ESQL using PASSTHRU Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358

mbnewbie wrote:
Hi,
Could not find any example whether the Oracle DESC <Table Name> command can be fired from ESQL in the form - SET Environment.Data[] = PASSTHRU('DESC MYTABLE');
MB Version is 8 and Oracle is 11g.
Getting exception as invalid SQL.

I guess you are talking about the describe command. You need to look at the Oracle documentation for the correct syntax of describe, then try it out in an Oracle command prompt. Once you have a working command, you can execute it from a Compute node using PASSTHRU, which is also documented in the IIB knowledge Center.
Back to top
View user's profile Send private message
mbnewbie
PostPosted: Wed Apr 20, 2016 2:24 am    Post subject: Reply with quote

Novice

Joined: 04 Oct 2013
Posts: 19

Oracle command is DESC table; this is working fine
but using command like SET Environment.Data[] = PASSTHRU('DESC table'); throws invalid SQL error.
Back to top
View user's profile Send private message
maurito
PostPosted: Wed Apr 20, 2016 2:41 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358

mbnewbie wrote:
Oracle command is DESC table; this is working fine
but using command like SET Environment.Data[] = PASSTHRU('DESC table'); throws invalid SQL error.

No, Oracle command is not DESC table;
It is
Code:
Usage: DESCRIBE [schema.]object[@db_link]

The reason it works from your command prompt is because you have logged in with your userid, which is also the schema name.
So, add the schema name and see what happens.
It would also help if you specify the exact error you are getting.
Back to top
View user's profile Send private message
mbnewbie
PostPosted: Thu Apr 21, 2016 12:48 am    Post subject: Reply with quote

Novice

Joined: 04 Oct 2013
Posts: 19

I am logged in as 'user' and it is also the same user/schema in the oracle DB.
I changed the syntax to - SET Environment.Desc[] = PASSTHRU('DESCRIBE user.MYTABLE') ; same error if I remove 'user' in the command.
The error as seen in debug perspective is [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement
Back to top
View user's profile Send private message
maurito
PostPosted: Thu Apr 21, 2016 1:12 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358

mbnewbie wrote:
I am logged in as 'user' and it is also the same user/schema in the oracle DB.
I changed the syntax to - SET Environment.Desc[] = PASSTHRU('DESCRIBE user.MYTABLE') ; same error if I remove 'user' in the command.
The error as seen in debug perspective is [Oracle][ODBC][Ora]ORA-00900: invalid SQL statement

The full error is
Code:
[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-00900: invalid SQL statement
So it looks like an ODBC driver problem. You need to raise a PMR with IBM
Back to top
View user's profile Send private message
mpong
PostPosted: Thu Apr 21, 2016 9:29 am    Post subject: Reply with quote

Disciple

Joined: 22 Jan 2010
Posts: 164

What does mqsicvp command says?
Back to top
View user's profile Send private message
maurito
PostPosted: Thu Apr 21, 2016 9:59 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358

mpong wrote:
What does mqsicvp command says?

Care to explain why you are asking that ?. The connection is being established, and the command rejected.
Back to top
View user's profile Send private message
johnyjohn
PostPosted: Mon Jan 29, 2018 2:33 am    Post subject: Any solution for this ? Reply with quote

Newbie

Joined: 29 Jan 2018
Posts: 2

Hi, I'm facing the same issue. I cannot find any suggestions on the web. Did you manage to resolve this ?
I need to run an oracle DESCRIBE command from ESQL..

I'm using IIB 10.0.0.9 and Oracle 11.
Thanks
Back to top
View user's profile Send private message
ase2015
PostPosted: Mon Nov 26, 2018 8:32 am    Post subject: Re: Any solution for this ? Reply with quote

Novice

Joined: 02 Sep 2015
Posts: 16

johnyjohn wrote:
Hi, I'm facing the same issue. I cannot find any suggestions on the web. Did you manage to resolve this ?
I need to run an oracle DESCRIBE command from ESQL..

I'm using IIB 10.0.0.9 and Oracle 11.
Thanks



I'm facing same issue, did you find asolution?
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Tue Nov 27, 2018 1:52 am    Post subject: Reply with quote

Knight

Joined: 17 Jul 2017
Posts: 516
Location: UK

hi...i think it is not supported as DESRIBE is an SQLPlus command, see the below links

https://coderanch.com/t/646948/application-servers/DESCRIBE-TABLENAME-java-sql-SQLSyntaxErrorException

https://docs.oracle.com/cd/B10501_01/server.920/a90842/ch13.htm

I had quick look at the DataDirect odbc options and couldn't find any options there as well,

http://media.datadirect.com/download/docs/odbc/allodbc/index.html#page/odbc%2Fconnection-option-descriptions-for-oracle-wire-p.html%23
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Using Oracle DESC in ESQL using PASSTHRU
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.