Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: Need help to correct a simple scriptby marto (Cardinal) |
on Jan 07, 2013 at 15:42 UTC ( [id://1012049]=note: print w/replies, xml ) | Need Help?? |
Hi, at first glance
Should be:
Also Oracle will complain about that SQL statement:
Shoud be:
See Use strict and warnings, Create Table and the DBI documentation. Pay attention to the section on placeholders and bind variables. Update: At second glance there's other problems. Let me fix this and update. Update 2: With Oracle (and perhaps other databases) Bind variables can be used for DML (Select, insert) but not DDL (Create, Alter, Drop) statements. (See What are the difference between DDL, DML and DCL commands?). This means that my previous advice on placeholders and bind variables won't help you much, though the topic is still worth reading. I'd try to create a stored procedure within Oracle to do the table create, and call if from your Perl script passing in the appropriate table name.
In Section
Seekers of Perl Wisdom
|
|