Wierd error in PL/SQL Package
ORA-01031 Insufficient Privileges
Now, I can understand if the silly thing NEVER worked, but WHY would I get THIS error after I've processed most of the records. The database is in 9i ver 2.
I've looked through the code and I can't see anywhere where it would be changing the USERID or password or anything like that so I'm a little stumped. Any and all assistance gratefully appreciated.
Try granting the user running this package a direct priviledge over the underlying table if you can and see if it changes some thing. Otherwise, probably a more thorough check over the lines of the code would be required.
What's the database version and o/s?
I have a package that does a global update of a rather large and complicated table schema. It had been working fine but, over the weekend, it failed after processing approximately 9,000 of 10,000 records with this error: ORA-01031 Insufficient Privil
Hi friends, We tried to generate a database package from Oracle Designer (10.1.2.6) and getting "syntax errors" but the package has no syntax errors when we copy and paste the code and compile in TOAD (10.6) Error from Designer: Server Generator
Hi , I have written a package specification given below : create or replace PACKAGE BILL_PACKAGE AS storeId varchar2(5); startDate varchar2(10); FUNCTION F_Bill(str_id IN tel_tr_ltm_bl_py.id_str_rt%TYPE,ws_id IN tel_tr_ltm_bl_py.id_ws%TYPE,v_date IN
Hi, I'm trying to connect to a database using the example code supplied in the docs here at java but I am getting the following error. Error: The name "SQLWarning" is not declared as a type. : C:\Program Files\Asymetrix\SuperCede\Projects\Projec
Hi all, I am using the JDeveloper (10.1.3.1.0) to publish a PL/SQL package as a Webservice, and I am having some troubles on the generation process. The problem that I am facing is on the generated code for the database side, where some methods have
Hello, With the help of ODM (version 10,2,0,3,1 -Build 479) I created a SVM classification model, which works very fine. After that, I generated the PL/SQL package, which returns an ORA-06512 in the call into DBMS_DATA_MINING.CREATE_MODEL. I tried to
This is the first time I'm running an SSIS package in SQL server agent. I'm running a SQL server agent job and getting this error message: Am I using the correct options? (options list below) Message Executed as user: SITEX\stxdatasqlexec. Microsoft
I come across a problem. My server is windows 2003 and Oracle is 10g Release 2. My previous DBA install Oracle 10g R1, 10gR2 and Oracle Data Warehouse Builder 10g on the same server at different Oracle_Home. When I came to this work. I tried to use R
Hi, I'm getting the following error , when calling a procedure. Any input appreciated please ORA-06502: PL/SQL: numeric or value error ORA-06512: at "package.procedure ", line 513 ORA-06512: at line 26 v_counter NUMBER; v_counter := 0; -- li
Hi, Script service_doctor.sql is run through repository owner. It is giving following error message. There are errors in one or more PL/SQL packages and functionPlatform properties have been loaded correctly Platform location has been seeded correctl
Hi all, first of all - my configuration: - OWB 10.0.3.0 - one Server HP-UX - two oracle database instances (plato and platodev) My problem: when i try to start "Deployment Manager" and try to connect to the platodev instance i get the RTC-5260 a
Hi, When I updated my function for the PL/SQL package, I get this error. Any help would be great. Thanks. create or replace package packagename as ERROR at line 1: ORA-00955: name is already used by an existing objectHi, You can't have a stand-alone
Dear Experts, Please tell me why i am getting Error ORA- 00900 while executing this script with Oracle10G Sql Browserbut not getting error with Oracle9i Sql Browser var r1 refcursor; var r2 refcursor; exec ETKT_CANCEL_TICKET_PCK.GET_DATA(:r1,:r2,'050
Hello, The problem I am confronted with is reusing generated models. In the process of DataMinig several steps are used: prepare data, Attribute selection (using AI), and building, testing and applying models. If PL/SQL packages are used two problems
Hi All, I need some help on how to change a custom PL/SQL package in ISG integration repository: I already uploaded my custom PL/SQL package to the integration repositoy some time ago. Now I have made some changes to PL/SQL record/table types defined
Hi All... I have a PL/SQl package and I am using JDEv 11g. I want to create it as a webservice. I want to deploy it in a remote server. Can I deploy it from my client machine. In server Weblogic already started. What are the prerequisites, that we ne
Hi, I am currently trying to upgrade my SQL 2014 evaluation version to the full version. I have purchased a Volume License for SQL Server 2014 Server/CAL and have extracted the product key from the ISO File. I have verified this product key with the
Hi All, I encounter the below error while running SSIS Package from Job or integration service. However on execution completes success fully while running from data tools. The issue occurs after migration to 2012 from 2oo5 dtsx. PFB the error. SSIS E
Hi , I'm coming across the following error while installing Microsoft SQL Server 2008R2 SQL Server Setup has encountered the following error: The required MSI package 'D:\SQL Sever 2008 R2 Developer Edition\x86\setup\sql_engine_core_shared_msi\sql_en
Hi, I am getting error while installing sql server std 2008 R2 on win 7 prof. sp1 64bit. I have already tried all option but fail to installation an error during the installation of assembly micro soft.vc80.crtHi, I am getting error while installing