Re^3: RFC: DBIx::Declare - generate code to call stored procs/SQL statements

Well, I don't actually care about Oracle, but postgres is a must-have for me :) I'll have a look at your code, but right now I'm upgrading my machine and still haven't reinstalled postgresql :)

Comment on Re^3: RFC: DBIx::Declare - generate code to call stored procs/SQL statements

Replies are listed 'Best First'.
Re^4: RFC: DBIx::Declare - generate code to call stored procs/SQL statements by Jenda (Abbot) on May 22, 2009 at 22:49 UTC
Hopefully you'll just need to implement a PostgreSQL specific _InferSQL. It's supposed to find the parameters of the stored procedure and set the SQL statement, the args array and the out_args hash (each key should point to an array containing the max size, the SQL type (DBI::SQL_INTEGER, ...) and the string containing the type ('varchar(100)',...). Contact me on jenda@krynicky.cz please once you have the necessary spare time :-) Jenda Enoch was right! Enjoy the last years of Rome.	[reply]

Replies are listed 'Best First'.

Re^4: RFC: DBIx::Declare - generate code to call stored procs/SQL statements
by Jenda (Abbot) on May 22, 2009 at 22:49 UTC

Hopefully you'll just need to implement a PostgreSQL specific _InferSQL. It's supposed to find the parameters of the stored procedure and set the SQL statement, the args array and the out_args hash (each key should point to an array containing the max size, the SQL type (DBI::SQL_INTEGER, ...) and the string containing the type ('varchar(100)',...). Contact me on jenda@krynicky.cz please once you have the necessary spare time :-)

Jenda
Enoch was right!
Enjoy the last years of Rome.

[reply]