Current Position:Home > oracle pls-00487

oracle pls-00487

  • PLS-00487: Invalid reference to variable 'RC_PARAMSGET' Updated:11-30

    Oracle 9.2 client ORA 8.1.7 Server: Trying to run an SP in SQL navigator ( or PL/SQL) I get the following error(s) ORA-06550: line 6, column 16: PLS-00487: Invalid reference to variable 'RC_PARAMSGET' ORA-06550: line 6, column 3: ++++++++++++++++++++

  • PLS-00487: Invalid reference to variable ' expression ' Updated:11-30

    oracle database 10G OS unix One of procedure is giving error PLS-00487: Invalid reference to variable '<expression>' while compilation in above database while it is compiling successfully in other database. Is there any database error?PLS-00487: Inv

  • Trouble with MSSQL Reporting Services and Oracle: PLS-00553: character set Updated:11-30

    First off, Oracle version is SQL is 64bit 2005 on Windows 2003 with all the latest patches. We’re using the Oracle 10.2 client on the SQL box. A few months ago queries against Oracle stopped working on our MSSQL reporting services server -

  • REPOST! Somebody @ Oracle pls look at this !!! Updated:11-30

    This page ("Getting Started with OracleAS Portal 10g"): contians a link ("Show me how to use the Edit mode toolbar!") to:

  • Migrating from SQL Server to ORACLE - Pls help Updated:11-30

    Hi All, I am a .Net developer. I am asked to migrate a project from SQL Server to ORACLE. Can anyone help me how to move forward. I used SQLDEVELPOR tool and migrated all the tables. But the Stored Procedures haven't got migrated properly. I need to

  • This is Urgent  . Can i expect quick response  from Oracle pls. Updated:11-30

    Hi , I have some items which are expired ones. When i publish category as a portlet i can also view the expired items belonging to that category . How can i hide them ? I wish to publish category portlet for the active items ONLY. Hope to get an earl

  • Oracle datasource lookup in JBOSS application server Updated:10-11

    Hi friends i have the below problem while configuring the datasource in JBOSS for oracle pls any body can help me out.......... i just want to create a data source for oracle in JBOSS 3.2.5 application server and i want to access that datasource from

  • Installation of translationhub in oracle 10g Updated:11-30

    hi i am completely stuck,i want to know how to install translation hub in oracle 10g.i feel lost after searching google and oracle.pls helphi i am completely stuck,i want to know how to install translation hub in oracle 10g.i feel lost after searchin

  • Oracle 8i Support / De Support Updated:11-30

    Hi, Can any one from Oracle pls let me know when 8i databases will be de-supported. I'm hearing that Oracle 8i DB will be de-supported by end of 2003. Is this true?. Where can i find this information. I would appreciate the earliest response. Thanks

  • PLS-00497: cannot mix between single row and multi-row (BULK) in INTO list Updated:11-30

    Hi, I have a requirement to send a table data through mail, so am using execute statement after opening the connection and am using the following PLSQL code, which am failing to execute successfully. My code goes like this.     0            10       

  • Oracle 10g test failure Updated:11-30

    i have succefully installed the oracle 10g onto win xp which is acting as a server and the client system on to another machine which is also running win xp. I am new to oracle, pls help me configure this. on my server, with the use of net manager, i

  • Workaround for opening a strongly typed cursor using native dynamic SQL Updated:11-30

    Hi All, In reading the PL/SQL documentation for Oracle 9i, I noted that the OPEN-FOR statement with a dynamic SQL string only allows the use of weakly typed cursors. I have verified this limitation with my own experimentation as follows: DECLARE type

  • Prompt for user inputs Updated:11-30

    Hi, 1) Want to prompt user for username & password 2) connect to oracle 3) want to use substring function on username entered by user 3) user of substring output in procedure Performed as shown below but not working, PROMPT Enter username and passwor

  • Sys_refcursor rowtype Updated:11-30

    BANNER Oracle Database 11g Enterprise Edition Release - 64bit Production PL/SQL Release - Production CORE     Production TNS for HPUX: Version - Production NLSRTL Version - Productionthis wor

  • Can not create dynamic SQL Updated:11-30

    DECLARE type seqarr is varray(10) of varchar2(50); seq seqarr; begin seq := seqarr('SEQ_A','SEQ_B','SEQ_C','SEQ_D'); FOR i IN seq.FIRST .. seq.LAST    loop       execute immediate 'alter sequence'||seq(i)||'increment by 900000000';       select seq(i

  • Config of multiple SQL-Server databases without multiple gateways-possible? Updated:11-30

    Hi Guys Can someone tell me if there's any way of connecting to different SQL Server databases (using Transparent Gateway) WITHOUT having to create multiple gateways? I have read in various sources that I MUST create one gateway per target database.

  • Issue - ORDM installation - 11g Updated:11-30

    We are trying to install ORDM in ORacle 11g. We are following the steps in the installation guide - Page 26 of the latest installation guide - While doing the Deploy and execute the project. While executing step number 4 - "RBIA_INTRA_ETL_FLW" w

  • OAS 4.0.X: Problems installing PLSQL Toolkit Updated:11-30

    After installing Oracle Application Server 4.0.7, which came bundled with the latest "beta" version of the JDeveloper 2.0 Suite,I attempted to install the PL/SQL Toolkit via the OAS Utilities Page. The connection being attempted is to a remote d

  • Call to WPG_SESSION API Failed. Error-Code:6550 Updated:10-11

    Can someone please help me figure out what I may be doing wrong? Using recent downloaded versions of 8i and 9iAS I cannot access Portal30 using IE5 browser. Please see error below. During portal configuration I specified connect string of oracle:1521

  • What is the wrong in this PL/SQL  block Updated:10-11

    Hi a... Can you please tell what is the wrong in this pl/sql block. declare TYPE TYP_NT_NUM IS TABLE OF NUMBER ; v_tab TYP_NT_NUM := TYP_NT_NUM(); TYPE uname is VARRAY(30) of varchar2(100) ; usr uname := uname ( 'u1','u2','u3','u4' ); TYPE pwd is VAR