Jump to content

OraFerro

Members
  • Content count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About OraFerro

  • Rank
    Newbie
  1. Hi all, I posted before regarding using oracle UDT stored procedure parameter type to pass a list of records for multiple insert using .net c#. I had the below example where a class definition is needed at .net side to map to oracle object. Unfortunately I did not apply this due to the extra mapping code that is needed. http://appsjack.blogspot.com.eg/2010/09/pass-custom-udt-types-to-oracle-stored.html My question is: did this change with oracle 12c? Can we now use: parameter.UdtTypeName = directOracleUTDName; //without the need for .net definition and mapping classes Thanks, Ferro
  2. Thanks Steve, I did that. Actually I have this routine as a function that returns that last statement and I call this function form the exception handling part in all other functions to log the SQL statement that caused the exception. The problem is that the return sql statement has position holders instead of actual values for the parameters. i.e. I get: INSERT INTO V_ACC_MAJOR_ACCOUNT VALUES (:B3 , :B2 , :B1 ) so I dont get the actual values of the parameters I my function filled in this SQL statement. I tried to look in v$sqltext, area, and address with no luck. I thought you there might be a lookup or something where the values of those parameters are stored for each SQL statement in v$sql. can you please help me with this?
  3. Hi All, I am trying to search a way to get the SQL statement that caused an exception withing an oracle function. I tried: SELECT sql_text from v$session ses, v$sql sql where sql.sql_id = ses.prev_sql_id and ses.sid = sys_context('userenv','SID') AND ROWNUM = 1; but this doesnt always return the last statement that the function has executed. if needed i can send the complete script for the funtion and its tables and stored procedures for testing. thanks a lot
×