Welcome to the Monastery | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
I am dynamically creating an Oracle SQL statement based from $ARGV and then I create an excel spreadsheet from the return of the data from the statement.
Now, in creating this dynamic SQL statement I create the statement and attempt to plug in the values for the unknowns in the statement via the DBI::execute() method (it is a method, right? :) I always get the terminology wrong, so if I did, please forgive me) from the arguments off the command line. *This* is where I get my error. See below... You will notice in the Perl code below that I am trying to execute that statement with the following:
Which is generated from: I get the error:
Now, I know why I am getting this error; because I am trying to call execute with the args as an array vs listing the args out manually. I tried to call the function with a join() attempting to join @args with commas effectively turning the args into a scalar separated by commas but I couldn't fool the execute command this way. So, I ask my fellow monks this simple question...What do you suggest I do? I will never know exactly what the end user wants, so there really are no definites. The dynamic-ness of this is quite nice. This issue is the only stumbling block I have.
_
_
_
_
_
_
_
_
_
_
In reply to DBI execute() args in array format (or similar) possible? by snafu
|
|