Helpful Links
   http://sourceforge.net/projects/cx-oracle

   http://www.python.net/crew/atuining/cx_Oracle/html/cursorobj.html

======================
Example:
Replace the data types as appropriate.

v_Vars = v_Cursor.setinputsizes(p_Result = cx_Oracle.NUMBER)
v_Cursor.execute("""
   begin
     :p_Result := sch.pkg.myfunction(:p_Param1, :p_Param2, :p_Param3);
   end;""",
   p_Param1 = 1,
   p_Param2 = "Some string",
   p_Param3 = "A different string")
print "Result:", v_Vars["p_Result"].getvalue()



On 8 Mar 2007 13:11:00 -0800, Greg Copeland <[EMAIL PROTECTED]> wrote:

I have  a need to call an Oracle function, which is not the same thing
as a stored procedure.  Can SQLAlchemy do this directly?  Indirectly?
If so, an example would be appreciated.  If not, how do I obtain the
raw cx_Oracle cursor so I can use that directly?

Thanks,

Greg

--
http://mail.python.org/mailman/listinfo/python-list

-- 
http://mail.python.org/mailman/listinfo/python-list

Reply via email to