Günce Kaya

Hello, I have created a package and procedure that include a function which defined in package body. This function has three parameter in package. When I change number of parameter of function in package body, I've got PLS-00323 error. Instance of package; CREATE OR REPLACE package SYSPROD.test_procedure is     function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2) return varchar2;     end test_procedure; / Instance of package body; CREATE OR REPLACE package body SYSPROD.test_procedure is     function test_inv (p_emplid in number,p_seqno in number,p_date in varchar2,p_invoice_address  varchar2)  return varchar2 is        PRAGMA AUTONOMOUS_TRANSACTION;     cursor c_cursor is                      /*sql statement as you need....                        ........................                        ........................*/                     /* Declarations ......*/       begin        .....     end; end test_procedure; You can se

Hello, If you create a package body and already close edit page, for editing package body, open schema browser in TOAD than right click and chose Load in Editor and do your changes in package body. Loves,

Hello, I've created a procedure and in the running time I've got that error. Make sure your scheme must have privileges to the tables that you use in your cursor in pl/sql script. I run bellow code and It works to me now. GRANT SELECT ON scheme_name.your_table_name TO your_scheme; Loves,

Hello, I got this error when I run insert script with select statement. This error about tablespaces. I just increased tablespace size. ALTER TABLESPACE PSTEMP ADD TEMPFILE '/data/PSPRD/oradata/pstemp_4.dbf' SIZE 1024M REUSE AUTOEXTEND ON NEXT 500M  MAXSIZE unlimited; Loves,

Hi, When I try to install Oracle client to windows machine, I got "INS-32025 Error" error. To overcome with that issue, go to C:\Program Files\Oracle\Inventory and delete Inventory file. Loves,

Hello, If you get this error when you run your trigger, you need to control your sql script. take out your into statement from your sql, run it and check it, If your result of sql script returns more than one row. Loves,

Hello, If you get this error, there are some multiple declarations for the identifications like below code. DECLARE zip_code INTEGER; Zip_Code INTEGER; -- duplicate identifier, despite Z/z case difference BEGIN zip_code := 90120; -- raises error here because of duplicate identifiers END; / Check your declarations and delete reiterated declaration one. Loves,

I created some indexes for a table. When I try to delete index which belong to that table, I got error ORA-02429.  To overcome with this issue I did something as bellow; alter table TABLE_NAME drop constraint INDEX_NAME; drop index INDEX_NAME; Loves,

Merhaba, Linux açılırken Grub Root Menu ye ulaşmanız gerekir. Bunun için Linux açılırken tuşlardan birine basın. Ekran görüntüsü aşağıdaki gibi olacaktır.