Re: Oracle SDO_GEOMETRY and DBI binding problem

in reply to Oracle SDO_GEOMETRY and DBI binding problem

You can't bind strings that look like functions and then expect them to still behave like functions. This might work:

my $insq = "insert into SHAPES (blah..blah) values (SDO_GEOMETRY(2003,
+NULL,NULL,SDO_ELEM_INFO_ARRAY(1,1003,3),SDO_ORDINATE_ARRAY(?,?,?,?)))
+";
$sth = $DBH->prepare($insq);
[download]

and then execute with appropriate values bound to the ?'s.

Comment on Re: Oracle SDO_GEOMETRY and DBI binding problem Download Code

Replies are listed 'Best First'.
Re^2: Oracle SDO_GEOMETRY and DBI binding problem by Anonymous Monk on Jul 11, 2008 at 18:38 UTC
Thanks for the suggestion runrig! I gave it a try, and still no dice ('Invalid number' error thrown). I'm guessing that the commas internal to the SDO object definition are confusing the binding. I tried various quoting combinations, and still no luck.	[reply]

Replies are listed 'Best First'.

Re^2: Oracle SDO_GEOMETRY and DBI binding problem
by Anonymous Monk on Jul 11, 2008 at 18:38 UTC

Thanks for the suggestion runrig!

I gave it a try, and still no dice ('Invalid number' error thrown).

I'm guessing that the commas internal to the SDO object 
definition are confusing the binding.  I tried various 
quoting combinations, and still no luck.

[reply]

In Section Seekers of Perl Wisdom