Stack Overflow
Stack Overflow

Questions tagged [ora-06550]

You tried to compile a block of PLSQL code, but a compilation error occurred.

You tried to compile a block of PLSQL code, but a compilation error occurred.

Refer to the line and column numbers (in the error message) to find the compilation error and correct it. Then try recompiling your code.

82 questions
18
votes
4 answers

"local collection types not allowed" error in PL/SQL ORA-06550

i am trying trying to get a query from oracle table called "sys.all_objects" into a string variable, so then i can give it to "dbms_obfuscation_toolkit.DESEncrypt" as input, after than encrypted string will go in to "utl_file" so i can write it…
Burak Atar
  • 183
  • 1
  • 1
  • 5
7
votes
2 answers

APEX: apex_application.g_print_error_message problem

When i'm using this command apex_application.g_print_success_message := 'Message'; to show success message is works fine but when i used the error command apex_application.g_print_error_message it gives me this…
macwadu
  • 907
  • 4
  • 24
  • 44
6
votes
3 answers

PLS-00103: Encountered the symbol "end-of-file" in simple update block

The following Oracle statement: DECLARE ID NUMBER; BEGIN UPDATE myusername.terrainMap SET playerID = :playerID,tileLayout = :tileLayout WHERE ID = :ID END; Gives me the following error: ORA-06550: line 6, column 15: PL/SQL: ORA-00933:…
rageingnonsense
  • 93
  • 1
  • 2
  • 7
6
votes
3 answers

Stored Procedure error ORA-06550

I'm getting compile errors with this code using sqlplus. My errors are: Warning: Procedure created with compilation errors. BEGIN point_triangle; END; Error at line 1: ORA-06550: Line 1, column 7: PLS-00905: object POINT_TRIANGLE is invalid …
user3002669
  • 63
  • 1
  • 2
  • 4
5
votes
1 answer

ORA-06550 wrong number or types of arguments when calling Oracle stored procedure

Have been fighting this for two days and am very frustrated but feel like I am making progress. After reviewing Oracle's online docs I am here. Receiving the following error upon code execution: ORA-06550: line 1, column 15: PLS-00306: wrong…
Geekender
  • 799
  • 4
  • 9
  • 18
5
votes
3 answers

What is the correct syntax to break a PL/SQL procedure call in multiple lines?

I am calling a PL/SQL procedure like this: execute util.verify(src_schema => '&username', stab => '&tab_name'); and I get these errors: SQL> execute util.verify(src_schema => '&username', BEGIN util.verify(src_schema =>…
Moeb
  • 10,527
  • 31
  • 84
  • 110
4
votes
3 answers

multiple instances of named argument in list

I have a problem executing oracle procedures from Visual Studio 2008's Server Explorer, when i try to execute a procedure all the input parameters are doubled! it only happend to me in one workstation, i've tried to reinstall oracle products, but it…
Guy Bertental
  • 584
  • 2
  • 10
  • 24
4
votes
2 answers

Using variables in PLSQL SELECT statement

I have a query that queries on ReportStartDate and ReportEndDate so I thought I would use variables in PLSQL. Not sure what I am missing here, but I get an error: CLEAR; DECLARE varReportStartDate Date := to_date('05/01/2010', 'mm/dd/yyyy'); …
Raj More
  • 47,048
  • 33
  • 131
  • 198
3
votes
4 answers

Running Oracle stored procs from C#

A beginner question: I have a stored proc (just a procedure, without any packages) in the Oracle Database: CREATE OR REPLACE procedure FII_DBO.CLEAR_UNIT_TEST_PRODUCT IS BEGIN ... END CLEAR_UNIT_TEST_PRODUCT; and it works fine in TOAD. However,…
Grzenio
  • 35,875
  • 47
  • 158
  • 240
3
votes
1 answer

Calling an Oracle stored procedure in C# using "Oracle.DataAccess" (with a parameter)

So I'm trying to call an Oracle stored procedure from my C# .NET application. Most online references I can find suggest "using System.Data.OracleClient;", but .Net 3.5 doesn't recognize that namespace so I'm using "Oracle.DataAccess.Client"…
KeithA45
  • 779
  • 2
  • 8
  • 11
3
votes
2 answers

Oracle Synonyms issue

My Scenario: Schema name: schema1 Package name: pkg_system procedure name: proc1 Now I am trying to create a synonyms for my proc1 as below CREATE PUBLIC SYNONYM call_proc FOR schema1.pkg_system.proc1; ...but it gave me syntax error. ORA-00933:…
niceApp
  • 2,913
  • 8
  • 35
  • 36
3
votes
1 answer

why an oracle procedure is invalid

Can someone please explain to me why I keep getting this PLS-00905 error for the below simple procedure? Thank you. create or replace procedure copy_table( table_name IN varchar2, database_link IN varchar2, suffix IN varchar2, …
Martin08
  • 20,990
  • 22
  • 84
  • 93
3
votes
1 answer

Actual source line in ORA-06550 message

When developing an Oracle PL/SQL procedure in Toad, I encounter errors like ORA-06550: line 97, column 25: PLS-00330: invalid use of type name or subtype name ORA-06550: line 97, column 9: PL/SQL: Statement ignored These given line numbers and…
Dennis
  • 1,071
  • 2
  • 17
  • 38
2
votes
1 answer

PLS-00103: Encountered the symbol "EXCEPTION" error while checking for a value in the bind variable

I am getting the below error for the PL/SQL block I executed. ORA-06550: line 16, column 1: PLS-00103: Encountered the symbol "EXCEPTION" when expecting one of the following: My anonymous procedure below was working fine until I included the…
ajay rk
  • 23
  • 1
  • 1
  • 3
2
votes
3 answers

Calling Oracle PL/SQL PLS-00201: identifier '001' must be declared

I am trying to call a PL/SQL script with the following header: PL/SQL: CREATE OR REPLACE PROCEDURE GETQUOTE(i_QUOTEID IN HR.QUOTEID, o_QUOTE OUT HR.QUOTE) Execute command: DECLARE c VARCHAR2(100); BEGIN …
Oh Chin Boon
  • 23,028
  • 51
  • 143
  • 215
1
2 3 4 5 6