Thanks for reply. I checked the link & it says if stored procedure end with
select statement, it will solve problem.
In my stored procedure, I am passing XML data, getting all values from that
xml & put into temp table.
CREATE PROCEDURE MY_PROC
> @empID char(10),
> @oldEmpList XML,
> @newEmpList XML,
> @Status INT OUTPUT
> AS
> CREATE TABLE #table_temp(advisory_id INT);
> INSERT INTO #table_temp
> SELECT Tbl.record.value('.','INT')
> FROM @oldEmpList.nodes('/emp/id') AS Tbl(record);
> SELECT * FROM #table_temp;
> RETURN
> GO
The above code get me error. If I just put select statement without
inserting anything like
SELECT Tbl.record.value('.','INT')
> FROM @oldEmpList.nodes('/emp/id') AS Tbl(record);
It gives me only first record. My guess is this is because of cursor.
Is there any workaround for this?
Thanks & Regards
Aniruddha Gaikwad
==============================================================
*With the new day, comes new strength and new thoughts. *
On Fri, Apr 4, 2014 at 10:39 PM, Michael Bayer <mike...@zzzcomputing.com>wrote:
> as far as I know, pyodbc does not support OUT parameters. The info they
> have on stored procs is here:
>
> http://code.google.com/p/pyodbc/wiki/StoredProcedures
>
> if you want to work with the Pyodbc cursor directly (or any other cursor,
> like that of pymssql perhaps):
>
> conn = my_session.connection()
> dbapi_conn = conn.connection
> cursor = dbapi_conn.cursor()
>
>
>
>
> the “isoutparam” flag is currently only understood by the cx_oracle
> dialect.
>
>
> On Apr 4, 2014, at 11:53 AM, anierud...@gmail.com wrote:
>
> Hi,
>
> I am trying to execute stored procedure from python / pyramid code. I am
> passing 3 input & 1 output parameter. But I am not able to receive output
> parameter back.
> Here is Stored Procedure
>
> CREATE PROCEDURE MY_PROC
> @empID char(10),
> @oldEmpList XML,
> @newEmpList XML,
> @Status INT OUTPUT
> AS
> -- sp body
> SET @Status = 1
> RETURN
> GO
>
>
> Here is Python code that calling stored procedure
>
> t = text('EXEC MY_PROC :empID, :oldEmpList, :newEmpList, :Status',
> bindparams=[bindparam('empID', type_=String, value='1234'),
> bindparam('oldEmpList', type_=TEXT,
> value='<emp><id>1</id><id>2</id>'),
> bindparam('newEmpList', type_=TEXT,
> value='<emp><id>e01</id><id>e02</id>'),
> bindparam('Status', type_=Integer, value=0,
> isoutparam=True)])
> result = CMS_DBSession.execute(t)print result.out_parameters
>
>
> Thanks
> Aniruddha
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+unsubscr...@googlegroups.com.
>
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "sqlalchemy" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/sqlalchemy/tbW_RVIRkGk/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> sqlalchemy+unsubscr...@googlegroups.com.
> To post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
