Current Position:Home > Commit in sp  having  globle table and function with autonomus transaction

Commit in sp  having  globle table and function with autonomus transaction

Update:11-30Source: network consolidation
Advertisement
hi gurus,
1)  i want to know if we populate a globle table in sp  then give  commit  then weather data will be present in globle table or not ..?
globle table :-
ON COMMIT delete  ROWS
NOCACHE;
2)  in same sp if we call a function having  autonomus transaction  and commit  then wath will happen ..

The Best Answer

Advertisement
1) i want to know if we populate a globle table in sp then give commit then weather data will be present in globle table or not ..?
globle table :-
ON COMMIT delete ROWS
NOCACHE;Data will be deleted from the Global Temporary Table.
2) in same sp if we call a function having autonomus transaction and commit then wath will happen ..Data Will not be deleted from the Global Temporary Table.
  • Commit in sp  having  globle table and function with autonomus transaction Update:11-30

    hi gurus, 1)  i want to know if we populate a globle table in sp  then give  commit  then weather data will be present in globle table or not ..? globle table :- ON COMMIT delete  ROWS NOCACHE; 2)  in same sp if we call a function having  autonomus t

  • Globle table  data  problem with pragma autonomous_tranaction Update:11-30

    hi gurus, i have  two globle table both having   preserve  row on commit g_emp ; g_hop_brk ; in  procedure    i m populating   g_emp  then  on this table  doing some manipulation    loop i m calling function  which  have  pragma autonomous_tranaction

  • Table-Valued function in oracle Update:11-30

    Hi All, I have a table-valued function in MS SQL Server, that I want to convert it. How can I create table-valued function in Oracle 9.2.0.1.0 Thanks for your thoughtsJust so we are talking the same language, array-type constructs in Oracle are gener

  • Table or function module to update ibase Update:11-30

    Hi experts, I am using the transaction crmd_order to create a sales order and i am assigning the warranty product to it , now my requirement is, i have to update that warranty product in the ibase( ib52 ). so for that what is the table or function mo

  • Inserting multiples rows into a table using function or procedure.. Update:11-30

    How do i insert multiples rows into a table using function or procedure? Please provide me query..Use FORALL bulk insert statement... eg: procedure generate_test_data as type cl_itab is table of integer index by pls_integer; v_cl_itab cl_itab; type c

  • Derive found flag in SQL with where clause using TABLE(CAST function Update:10-11

    Dear All, Stored procedure listEmployees ========================== CREATE OR REPLACE TYPE STRING_ARRAY AS VARRAY(8000) OF VARCHAR2(15); empIdList STRING_ARRAY countriesList STRING_ARRAY SELECT EMP_ID, EMP_COUNTRY, EMP_NAME, FOUND_FLAG_ FROM EMPLOYEE

  • Problem with dg4msql and table-valued functions Update:10-11

    Have configured dg4msql to connect from my oracle db to ms sql server. Am able to do simple SELECTs from ms sql tables like: select * from "sys"."procedures"@dg4msql; or select * from "dbo"."SomeTable"@dg4msql; But

  • Table or Function module to get Internal order planning and Cost element pl Update:10-11

    Dear All, Table or Function module to get Internal order planning and Cost element planning. Internal order planning from T-code KO13. Thanks in advance. Regards, Ravi Edited by: Ravi Chandra on Sep 13, 2011 8:08 AMBPEJ, BPEG, BPEPRead other 2 answer

  • TABLE(CAST()) function not returning the correct results in few scenarios. Update:10-11

    I am using TABLE(CAST()) operation in PL/SQL and it is returning me no data. Here is what I have done: 1.     Created Record type CREATE OR REPLACE TYPE target_rec AS OBJECT target__id          NUMBER(10), target_entity_id NUMBER(10), dd           CH

  • Vendor-Customer balances in group currency-table/structure/function module? Update:10-11

    Hi All, Which table/structure/function module can be used to get balances for vendors and customers in group currency? We just wnat to extract balances in group currency so FBL1N and FBL5N are not options. Is there any SAP report which can provide th