Re: Template::Plugin::DBI, Oracle and cursors

Replies are listed 'Best First'.
Re^2: Template::Plugin::DBI, Oracle and cursors by holli (Abbot) on Aug 30, 2005 at 12:51 UTC
Thank you. As advised in Oracle Cursors Exceeded, I changed my code to use a prepared query and placeholders. I changed my code to: `[% query = oracleDB.prepare('"SELECT * FROM mytable WHERE FOO = ? AND +BAR = ?"') %] #... [% FOREACH vorgang = query.execute(kasse.FOO, kasse.BAR) %]` [download] But then I get `undef error - Bad hash at C:/Perl/site/lib/Template/Plugin/DBI.pm line + 366.` [download] :( As you may have spotted, there is a stupid copy & paste typo in the code above (2 quote marks). This is corrected now and the program runs like a charm. Thanks again for the hint. :)) The correct code: `[% query = oracleDB.prepare('SELECT * FROM mytable WHERE FOO = ? AND B +AR = ?') %] #... [% FOREACH vorgang = query.execute(kasse.FOO, kasse.BAR) %]` [download] holli, /regexed monk/	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: Template::Plugin::DBI, Oracle and cursors
by holli (Abbot) on Aug 30, 2005 at 12:51 UTC

[% query = oracleDB.prepare('"SELECT * FROM mytable WHERE FOO = ? AND +BAR = ?"') %] #... [% FOREACH vorgang = query.execute(kasse.FOO, kasse.BAR) %]
[download]
But then I get
undef error - Bad hash at C:/Perl/site/lib/Template/Plugin/DBI.pm line + 366.
[download]
:(

stupid copy & paste typo

[% query = oracleDB.prepare('SELECT * FROM mytable WHERE FOO = ? AND B
+AR = ?') %]
#...
  [% FOREACH vorgang = query.execute(kasse.FOO, kasse.BAR) %]
[download]

holli, /regexed monk/

[reply]
[d/l]
[select]