Oracle Error 6550 Fdpstp Cause
Contents |
here for a quick overview of the site Help Center Detailed answers to any
What Is Fdpstp In Oracle
questions you might have Meta Discuss the workings and policies of fdpstp failed due to ora-06502 this site About Us Learn more about Stack Overflow the company Business Learn more about pls-00201: hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Ora-06550: Line 1, Column 7:
is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cause: FDPSTP failed due to ORA-06550: line 1, column 7:PLS-00221: is not a procedure or is undefined up vote 0 down vote favorite I'm trying to run a concurrent request in
Pls-00306
APPS but i keep getting this error (Cause: FDPSTP failed due to ORA-06550: line 1, column 7: PLS-00221: 'XXINV_ITEM_ORACLE_E5B0' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored) and heres my package body its just a simple insert. CREATE OR REPLACE PACKAGE BODY APPS.XXINV_ITEM_ORACLE_E5B0 IS PROCEDURE inv_com_proc ( o_chr_errbuf OUT VARCHAR2, o_num_retcode OUT NUMBER ) AS begin EXECUTE IMMEDIATE 'TRUNCATE TABLE XXINV.XXINV_ITEM_ORACLE_E5B0'; Insert into XXINV.XXINV_ITEM_ORACLE_E5B0(ORGANIZATION_CODE , ITEM_NUM, ON_HAND_QUANTITY , ITEM_TYPE , STATUS , MATERIAL_COST , MATERIAL_OVERHEAD_COST, RESOURCE_COST, OVERHEAD_COST, OUTSIDE_PROCESSING_COST, SUBINVENTORY_CODE , LOCATORS ) select OWNING_ORG_CODE, ITEM_NUMBER, ON_HAND_QUANTITY, ITEM_TYPE, STATUS, MATERIAL_COST , MATERIAL_OVERHEAD_COST, RESOURCE_COST, OVERHEAD_COST, OUTSIDE_PROCESSING_COST, SUBINVENTORY_CODE , LOCATOR from apps.XXRPT_INV_VALUATION_D535_V where apps.XXRPT_INV_VALUATION_D535_V.SUBINVENTORY_CODE = 'FG' AND apps.XXRPT_INV_VALUATION_D535_V.STATUS = 'ONHAND'; COMMIT; END; end XXINV_ITEM_ORACLE_E5B0; oracle plsql share|improve this question edited Aug 3 '12 at 20:31 DCookie 28.9k84765 asked Aug 3 '12 at 19:27 AmericanSuave 59138 add a comment| 2 Answers 2 active oldest votes up vote 2 down vote accepted
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java Clipart Techie Humor Advertisement Oracle Basics ALIASES AND AND & OR BETWEEN COMPARISON OPERATORS pls-00103 DELETE DISTINCT EXISTS FROM GROUP BY HAVING IN INSERT INSERT ALL INTERSECT IS NOT
Pls-00907: Cannot Load Library Unit
NULL IS NULL JOIN LIKE MINUS NOT OR ORDER BY PIVOT REGEXP_LIKE SELECT SUBQUERY TRUNCATE UNION UNION ALL UPDATE WHERE Oracle pls-00905 object is invalid Advanced Oracle Cursors Oracle Exception Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions Oracle / PLSQL: ORA-06550 Error Message Learn the http://stackoverflow.com/questions/11802076/cause-fdpstp-failed-due-to-ora-06550-line-1-column-7pls-00221-is-not-a-proc cause and how to resolve the ORA-06550 error message in Oracle. Description When you encounter an ORA-06550 error, the following error message will appear: ORA-06550: line num, column num: str Cause You tried to execute an invalid block of PLSQL code (like a stored procedure or function), but a compilation error occurred. Resolution The option(s) to resolve this Oracle error are: Option #1 Refer to the line and column numbers (in https://www.techonthenet.com/oracle/errors/ora06550.php the error message) to find the compilation error and correct it. Then try recompiling your code. Let's look at an example of how to resolve an ORA-06550 error. For example, if you created a procedure called TestProc as follows: SQL> CREATE OR REPLACE PROCEDURE TestProc 2 AS 3 vnum number; 4 BEGIN 5 vnum := vAnotherNum; 6 END; 7 / Warning: Procedure created with compilation errors. This procedure was created with compilation errors. So if we try to execute this procedure, we will get an ORA-06550 error as follows: SQL> execute TestProc(); BEGIN TestProc(); END; * ERROR at line 1: ORA-06550: line 1, column 7: PLS-00905: object EXAMPLE.TESTPROC is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored You can run the SHOW ERROR command to view the errors as follows: SQL> show error procedure TestProc; Errors for PROCEDURE TESTPROC: LINE/COL ERROR -------- ----------------------------------------------------------------- 5/1 PL/SQL: Statement ignored 5/9 PLS-00201: identifier 'VANOTHERNUM' must be declared As you can see, the error is caused by the variable called VANOTHERNUM not being declared. To resolve this error, we can modify our TestProc procedure to declare the variable as follows: SQL> CREATE OR REPLACE PROCEDURE TestProc 2 AS 3 vnum number; 4 vAnotherNumber number; 5 BEGIN 6 vAnotherNum := 999; 7 vnum := vA
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/i-cannot-execute-a-procedure-in-the-application-1122365 Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP http://beginapps.blogspot.com/2007/09/fdpstp-failed-due-to-ora-06550.html Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES EdgeWave Sophos Pivotal CRM Wave Direct View All Topics View All Members View All Companies Toolbox for IT oracle error Topics Oracle Groups Ask a New Question Oracle Applications Your premier resource for objective technical discussion and peer-to-peer support on Oracle Applications. Home | Invite Peers | More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The oracle error 6550 Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. I CANNOT EXECUTE A PROCEDURE IN THE APPLICATION Marcos asked Aug 8, 2006 | Replies (10) I have developed a pl/sql procedure in it, I load account information. When I execute this procedure all it`s correct, all the tables are loaded in a correct way. begin xxmovban; end; But when I execute this procedure since the application it returns the following error : ORACLE error 6550 in FDPSTP Cause : FDPSTP failed due to ORA-06550: line 1,column 7: PLS-00306: wrong number or types of arguments in call 'NAME_PROCEDURE' PL/SQL : statement ignored . But my procedure doesn´t have any parameter!!! How can I solve this problem???? Join this group Popular White Paper On This Topic Best Practices for a BI and Analytics Strategy 10Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... kailashkr replied Aug 8, 2006 Two parameters errorbuf and retcode (both varchar2) are mandatory for every procedure being called from co
rights reserved.FNDGACST module: Gather All Column Statistics+---------------------------------------------------------------------------+Current system time is 24-SEP-2007 17:00:11+---------------------------------------------------------------------------+**Starts**24-SEP-2007 17:00:11ORACLE error 6550 in FDPSTPCause: FDPSTP failed due to ORA-06550: line 1, column 7:PLS-00307: too many declarations of 'GATHER_ALL_COLUMN_STATS' match this callORA-06550: line 1, column 7:PL/SQL: Statement ignored.The SQL statement being executed+---------------------------------------------------------------------------+Start of log messages from FND_FILE+---------------------------------------------------------------------------++---------------------------------------------------------------------------+End of log messages from FND_FILE+---------------------------------------------------------------------------+Successfully resubmitted concurrent program FNDGACST with request ID 316257 to start at 25-SEP-2007 17:00:00 (ROUTINE=AFPSRS)+---------------------------------------------------------------------------+Executing request completion options...Finished executing request completion options.+---------------------------------------------------------------------------+Exceptions posted by this request:Concurrent Request for "Gather All Column Statistics" has completed with error.+---------------------------------------------------------------------------+Concurrent request completedCurrent system time is 24-SEP-2007 17:00:11+---------------------------------------------------------------------------+SolutionsA) Execute the following workaround:1.System Administrator, Concurrent > Program > Defile,2.Query the report and press 'Parameters' button,3.Add the two missing HMODE and INVALIDATE parameters to definition of FNDGCLSTEx:8, Hmode, Hmode, Vset: 30 Characters, Required:N, Security:N, Display:Y9, Invalidate, Invalidate, 1 char, Required:N, Security:N, Display:Y Posted by Ramesh Mani Labels: Trouble Shooting for Ebiz 2 comments: firoj said... Sagol kothakar... September 19, 2012 at 1:03 PM Sridevi Ko