calling stored procedure in TDI -7

[mazha]

Hi All,

I am calling a stored procedure to insert data to oracle from TDS.

1. In feed section,TDS is using LDAP connector mode iterator
2. In data flow im using JDBC connector in Add only mode

My question is

1. When calling SP what should be "Table Name" in connection
section.Table Name is a required attribute
2, Where should I add the SP ? Can I add that in Table Name section
"Advanced JS section" or in hooks section.

If its in hooks section which hook I should use?

Any help appreciated.

.

[Eddie Hartman]

Have a look here, Mazha:

http://www.google.com/url?sa=D&q=http://www.tdi-users.org/twiki/bin/view/Integrator/TDIFAQ%23mozTocId67054&usg=AFQjCNEuASlsQ_OuoUukBb3tLScw2-d1XQ

Standard TDI Connector behavior does not include calling stored
procedures, but you can do this yourself using JavaScript and the
pipe the Connector has opened to the connected system.

For more info on what the JDBC Connectors lets you do,
check out the JavaDocs -- the class is called JDBCConnector
and it offers some handy stuff like commit() /rollback() and
execSQL(). The JavaDocs are found here:

%TDI_INSTALLDIR%/docs/api/index.html

Or from the CE of TDI 6 then select Help > Low Level API,
or in TDI 7 it's linked in the Help > Welcome page.

Hope this helps!
-Eddie

[mazha]

I can call the procedure and my code is working well.

The problem I am facing is

1. The connector is trying to insert the values to a table. since no
table is selected its trying to insert to "null" and throwing an
exception.

So my question where to i keep the SP to override that behavior. Hope
I am clear this time.

On Dec 5, 11:21 am, Eddie Hartman <eddiehart...@gmail.com> wrote:
> Have a look here, Mazha:
>

> http://www.google.com/url?sa=D&q=http://www.tdi-users.org/twiki/bin/v...

[Eddie Hartman]

On Dec 6, 2:59 pm, mazha <sunitha.raghura...@gmail.com> wrote:
> I can call the procedure and my code is working well.
>
> The problem I am facing is
>
> 1. The connector is trying to insert the values to a table. since no
> table is selected its trying to insert to "null" and throwing an
> exception.
>
> So my question where to i keep the SP to override that behavior. Hope
> I am clear this time.
>
> On Dec 5, 11:21 am, Eddie Hartman <eddiehart...@gmail.com> wrote:
>
>
>
> > Have a look here, Mazha:
>
> >http://www.google.com/url?sa=D&q=http://www.tdi-users.org/twiki/bin/v...
>
> > Standard TDI Connector behavior does not include calling stored
> > procedures, but you can do this yourself using JavaScript and the
> > pipe the Connector has opened to the connected system.
>
> > For more info on what the JDBC Connectors lets you do,
> > check out the JavaDocs -- the class is called JDBCConnector
> > and it offers some handy stuff like commit() /rollback() and
> > execSQL(). The JavaDocs  are found here:
>
> >    %TDI_INSTALLDIR%/docs/api/index.html
>
> > Or from the CE of TDI 6 then select Help > Low Level API,
> > or in TDI 7 it's linked in the Help > Welcome page.
>
> > Hope this helps!
> > -Eddie
>

Put your Connector in Passive state. Unlike Enabled state,
Passive means that the Connector is initialized and closed
when the AL starts/stops, but is never used -- except by you
via script.