Wierd error in PL/SQL Package

October 11 0
Advertisement
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 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.
Leigh Smith
Advertisement
This is strange. The error that comes up for the insufficient privs is normally due to the privs being granted from the roles and tried to be used in the packages/procedures. That gives us the insufficient priviledge error. But , if it worked before, it should work now too.
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?
HTH
Aman....
Wierd error in PL/SQL Package

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

CDS-11025 Error: Oracle Designer generation error with PL/SQL package

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

Error with PL/SQL package

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

Error returned using SQL package

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

Error when publishing a PL/SQL package as a Webservice

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

Error in PL/SQL generated package

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

Getting an error running an SSIS package from SQL server agent

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

Starting Rman getting error PL/SQL package not current

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

ORA-06502: PL/SQL: numeric or value error ORA-06512: at "package.proc

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

Service_doctor.sql -- There are errors in one or more PL/SQL package

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

"There are errors in one or more PL/SQL packages and functions"

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

Error in recompiling a PL/SQL package

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

Error with Oracle10G Sql Browser while execute package with exec clause

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

Creating PL/SQL packages

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

How to get changes of a custom PL/SQL package updated in ISG?

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

Creating a webservice from PL/SQL Package in JDev 11g

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

Error in converting SQL 2014 Trial to Full version using VLKey

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

Error while running SSIS package from Integration service or via Job

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

SETUP ERROR WHILE INSTALLING SQL SERVER 2008 R2

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

Getting error while installing sql server std 2008 R2 on win 7 prof. sp1 64bit

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