On Wednesday, June 13, 2012 11:15:46 PM UTC-7, Balaji Mohandas wrote:
>
> Hi All,
>
> I am currently working on an Client/Server app which extensively use
> Oracle Stored Procedures (Business Logic) and working on Proof of Concept,
> migrating it to Web Solution using Sinatra and Sequel.
>
> While going through Sequel documentation, I went through couple of
> examples, on how to use the stored procedure, but this is very minimal. It
> would be a great help if some could share some links on how to make calls
> to stored procedures, especially using Oracle.
>
> Also, can you please let me know, about the Sequel support for Oracle
> stored proc with IN/OUT parameters is available in the current release or
> in the near future. Also the current Oracle PL/SQL implementation
> extensively use REF cursors to return recordset from the DB, is it possible
> for me retrieve the record set using Sequel ORM.
>
I don't believe Sequel's stored procedure support handles IN/OUT
parameters. You'll have to drop down the the connection level and use the
driver's methods:
DB.synchronize do |conn|
# conn here is an OCI8 or JDBC connection object
# depending on your adapter
end
As for returning record sets, if it is handled similarly to an SQL query,
that may work.
I'll accept patches to improve the stored procedure support if they come
with specs, but I have no plans to work on this myself.
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/_V1lRB5ireQJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
