Skip to main content

PL/SQL Inserting Big Data Using Refcursor and Fuction

--Inserting big data using refcursor and function

declare
  cursor c_beyan
  is
  select *
  from ilc_beyan
  order by id;
 
    v_KENTLI_ID           ilc_beyan.kentli_id%TYPE;
    v_ISLEM_ADRESLERI_ID  ilc_beyan.islem_adresleri_id%TYPE;
    v_HESAP_ID            ilc_beyan.hesap_id%TYPE;
    v_DONEM_YILI          ilc_beyan.donem_yili%TYPE;
    v_DONEM_AYI           ilc_beyan.donem_ayi%TYPE;
    v_BIRIM_ADET          ilc_beyan.birim_adet%TYPE;
    v_ACIKLAMA            ilc_beyan.aciklama%TYPE;
    v_BEYAN_TUTARI        ilc_beyan.beyan_tutari%TYPE;
    v_KAPANIS_ID          ilc_beyan.kapanis_id%TYPE;
    v_counter number      :=0;
 
begin
    for r_beyan in c_beyan loop
        v_KENTLI_ID           :=r_beyan.kentli_id;
        v_ISLEM_ADRESLERI_ID  :=r_beyan.islem_adresleri_id;
        v_HESAP_ID            :=r_beyan.hesap_id;
        v_DONEM_YILI          :=r_beyan.donem_yili;
        v_DONEM_AYI           :=r_beyan.donem_ayi;
        v_BIRIM_ADET          :=r_beyan.birim_adet;
        v_ACIKLAMA            :=r_beyan.aciklama;
        v_BEYAN_TUTARI        :=r_beyan.beyan_tutari;
        v_KAPANIS_ID          :=r_beyan.kapanis_id;
        v_counter             :=promigrate.pkg_mig_thk.fnc_beyan_id_al;
       
        insert into ilc_beyan
        (
            ID,
            KENTLI_ID,
            ISLEM_ADRESLERI_ID,
            HESAP_ID,
            DONEM_YILI,
            DONEM_AYI,
            BIRIM_ADET,
            ACIKLAMA,
            BEYAN_TUTARI,
            KAPANIS_ID,
            KAYIT_KULLANICI_ID,
            KAYIT_TARIHI
        )
        values
        (
            v_counter,
            v_KENTLI_ID,
            v_ISLEM_ADRESLERI_ID,
            v_HESAP_ID,
            v_DONEM_YILI,
            v_DONEM_AYI,
            v_BIRIM_ADET,
            v_ACIKLAMA,
            v_BEYAN_TUTARI,
            v_KAPANIS_ID,
            1,
            sysdate
        );
      end loop;
end;

--Executing a function
 declare
          v_counter number:=0;
 begin
          select promigrate.pkg_mig_thk.fnc_beyan_id_al
          into v_counter
          from dual;
         
          dbms_output.put_line(v_counter);
 end;
Labels:

Comments

Post a Comment

Popular posts from this blog

How to fix Git push error: "RPC failed; curl 56 HTTP/2 stream 7 was reset send-pack: unexpected disconnect while reading sideband packet fatal: the remote end hung up unexpectedly"

Problem Today I saw the following problem when I tried to push my changes to a Git server after doing some work for upgrading an Umbraco v7 project to v8.18.8.  Possible reasons After some investigations, it seems like this could be because of the following reasons; Git is not happy with the amount of changes that are being pushed into the server.  There are possible limitations on the server about the size/amount of files that you can push. Your internet connection is not good and stable enough. Your Git client's version is old. Solution options For me, the easiest option was connecting to another Wifi and trying again. Apparently, this option helped quite a few people, so it is worth giving it a try. Unfortunately, it didn't work for me. A bad internet connection wasn't an option for me either, as my internet is pretty fast (500 Mbps). Similarly, my Git client version was the latest version (git version 2.41.0.windows.3).  On StackOverflow, there were a lot of recommend...
Post a Comment
Read more

How to use JQuery Ajax Methods for Async ASP.NET MVC Action Methods

Making repeatedly calls to async methods can be a nightmare. In this case, it makes sense to use 2 ajax methods, instead of one. Here is a simple solution to overcome this problem. See that  ajaxcalls   is emptied after the success response for the first ajax call and then the second ajax method is used to make one single call to the async action method. Hope it helps. View: @section Scripts{     < script type ="text/javascript">         var smartDebitObject = new Object();         smartDebitObject.MembershipNumber = $( "#MembershipNumber" ).val();         smartDebitObject.ProfileId = $( "#ProfileId" ).val();         smartDebitObject.FirstName = $( "#FirstName" ).val();         smartDebitObject.LastName = $( "#LastName" ).val();     ...
Post a Comment
Read more

How to fix "Microsoft SQL Error SQL71564: Error validating element [USERNAME]: The element [USERNAME] has been orphaned from its login and cannot be deployed."

I needed to export a database in BACPAC format today in order to restore it somewhere else, and I encountered the following error. To resolve this issue, I deleted all of the users mentioned in the error log. After successfully creating the BACPAC file, I used it to create a new database with no problems. Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: Error validating element [USER1]: The element [USER1] has been orphaned from its login and cannot be deployed. Error SQL71564: Error validating element [USER2]: The element [USER2] has been orphaned from its login and cannot be deployed. Error SQL71564: Error validating element [USER3]: The element [USER3] has been orphaned from its login and cannot be deployed. Error SQL71564: Error validating element [USER4]: The element [USER4] has been orphaned from its login and cannot be deployed. Error SQL71...
Post a Comment
Read more