Python and calling Oracle Procedures

[Benny the Guard]

I have a procedure (within a package) that generates a

CREATE OR REPLACE PACKAGE my_pack AS
TYPE my_type AS TABLE OF VARCHAR2;
 
PROCEDURE my_get_proc (my_records OUT my_type) AS
BEGIN
  SELECT NAME BULK COLLECT INTO my_records FROM my_table;
END my_get_proc;
END my_pack;

So my question is how do I call this from Python and get the results returned to me? Do I just need to:

db = DCOracle2.connect(<connect string>)
c = db.cursor()
my_record_list = c.prodecure.my_pack.my_get_proc ()

Do OUT params get translated into return values?

[amitpatel66]

I have a procedure (within a package) that generates a

CREATE OR REPLACE PACKAGE my_pack AS
TYPE my_type AS TABLE OF VARCHAR2;
 
PROCEDURE my_get_proc (my_records OUT my_type) AS
BEGIN
  SELECT NAME BULK COLLECT INTO my_records FROM my_table;
END my_get_proc;
END my_pack;

So my question is how do I call this from Python and get the results returned to me? Do I just need to:

db = DCOracle2.connect(<connect string>)
c = db.cursor()
my_record_list = c.prodecure.my_pack.my_get_proc ()

Do OUT params get translated into return values?

Did you try running your PHP code?
Does it error out or not?
Please post back if it does not work?

[amitpatel66]

[quote=Benny the Guard]I have a procedure (within a package) that generates a

CREATE OR REPLACE PACKAGE my_pack AS
TYPE my_type AS TABLE OF VARCHAR2;
 
PROCEDURE my_get_proc (my_records OUT my_type) AS
BEGIN
  SELECT NAME BULK COLLECT INTO my_records FROM my_table;
END my_get_proc;
END my_pack;

So my question is how do I call this from Python and get the results returned to me? Do I just need to:

db = DCOracle2.connect(<connect string>)
c = db.cursor()
my_record_list = c.prodecure.my_pack.my_get_proc ()

Do OUT params get translated into return values?

Try this:

db = DCOracle2.connect(<connect string>)
c = db.cursor()
c.prodecure.my_pack.my_get_proc (my_record_list)
 

[Benny the Guard]

Tried both ways and Python gives an error. Specifically I see:

Traceback (most recent call last):
File "C:\dev\Python23\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py" , line 310, in RunScript
exec codeObject in __main__.__dict__
File "C:\test.py", line 19, in ?
print ("**********************************")
File "C:\Python23\lib\site-packages\DCOracle2.py", line 1526, in __call__
cursor.execute(sql,__plist=args)
File "C:\Python23\lib\site-packages\DCOracle2.py", line 1001, in execute
result = self._cursor.execute()
DatabaseError: (24358, 'ORA-00000: normal, successful completion')


Any other ideas on how to get this to work?