Günce Sarıkaya

Hello, This error indicate that user's permission have some absences like PTPT1000 or HCCPCSSA1010 or HCDPALL.. add one of that permissions or give a role that has permission upper ones.  If you want you can add on permission list as bellow, Loves,

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,