3

I tried calling a stored procedure using DatabaseReader node but it does not worked for me.

Can anyone suggest me how I can call a stored procedure in Knime?

Thanks, Krishna

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Krishna
  • 486
  • 8
  • 20
  • Could you show us how did you tried to call the stored procedure? What database do you use? – Gábor Bakos Jun 11 '14 at 12:49
  • using Database Reader Node, I am using TeraData. In SQL Statement section, i am adding text to call a SP. for e.g Call .TESTSP ('123',121,a) – Krishna Jun 12 '14 at 11:09
  • Sorry, I have no access to TeraData to check. The code of the Database Reader node suggests stored procedures might work with the Database Reader. Try to call it with a dummy call after it (assuming you do not need the result of the stored procedure), like: `Call .TESTSP ('123',121,a); select * from aTableName`. – Gábor Bakos Jun 12 '14 at 12:29
  • i check in logs actually knime is appending "Select * from (" to SP call. – Krishna Jun 18 '14 at 11:10
  • Yes, that is why I suggested to add an additional call for a non-stored procedure select. Only the last statement is wrapped with that `select * from (...)`, so the stored procedure might get called before interfering with it. – Gábor Bakos Jun 18 '14 at 11:22
  • i tried that too but its not working. only option i can see is to develop new node. – Krishna Jun 18 '14 at 12:00

1 Answers1

2

by setting the option "Run SQL Query only during execute, skips configure" on configure dialog. we can execute SP using database reader node.

thanks, Krishna

Krishna
  • 486
  • 8
  • 20