Skip to Content
avatar image
Former Member

Executing stored procedure using sql transform in bods

I have to execute a procedure and make it as my source.. I did it through sql transforma by calling the sp in it.. For one particular procedure the schema doesn't map saying it uses temp tables.. The proc is in sql server and i have used temp tables in it.. Kindly hel..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 28, 2017 at 02:56 PM

    Does the stored procedure restuns a table?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 28, 2017 at 03:52 PM

    Hi Vivek,

    Can you please explain why do you want to use temporary tables in Stored Procedure code. Data services will not work with temporary tables as they exists only for a particular session.

    Every Dataflow and sql() call is a separate connection to the database. The TEMPORARY table(#table_name) is cleared out when a session is disconnected.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded