DCOracle Large Objects

Aahz Maruch aahz at netcom.com
Tue Jan 18 11:10:08 EST 2000


In article <Pine.LNX.4.21.0001181545370.15178-100000 at fep132.fep.ru>,
Oleg Broytmann  <phd at phd.russ.ru> wrote:
>
>   Anyone can help with Oracle LOBs and stored procs?
>   I want to create a LOB in a database. DB programmer created a stored
>procedure for me, but when I call it, passing data as Python string:
>
>   cursor.execute("add_image", [1028, "This is the body of my Large Object"])
>
>I got the error "invalid SQL". How do I pass the body of LOB to stored proc?

I don't know Oracle SQL, but you usually need to use "EXEC add_image" to
call a stored proc.
--
                      --- Aahz (@netcom.com)

Androgynous poly kinky vanilla queer het    <*>     http://www.rahul.net/aahz/
Hugs and backrubs -- I break Rule 6

Have a *HAPPY* day!!!!!!!!!!



More information about the Python-list mailing list