Home ›
All Tags » Oracle » Parameters (RSS)

Browse by Tags

Related Posts

  • Getting multiple rows from oracle stored procedure and binding it to grid view

    To get this stuff you need to create a Ref Cursor to return recordset. create or replace PACKAGE Types AS TYPE cursor_type IS REF CURSOR; END Types; Now create a stored procedure to return multiple rows . create or replace PROCEDURE getAllCity(p_recordset OUT types.cursor_type) AS BEGIN OPEN p_recordset...
    Posted to Oracle (Forum) by yeotumitsu@sify.com on 04-15-2008, 12:00 AM
    Filed under: Oracle, Parameters, ref cursor, stored procedure, type, bind, direction, grid view

  • Re: Return "Record Added" string from an Oracle Stored Procedure

    Discovered the problem ... Made a change to the VB Stored Procedure calling code on my ASP.Net page. My incorrect output parameter code was as follows: Dim objStatusParam As New OracleParameter( "Status" , OracleDbType.Varchar2) The output parameter code that worked looks like this: Dim objStatusParam...
    Posted to Oracle (Forum) by John Happy on 01-22-2008, 12:00 AM
    Filed under: Oracle, Parameters, asp.net

  • column datatype in oracle and dataset table

    Hi all, I have an Oracle table with column of datatype NUMBER(10). When I add a tabledapter in dataset designer, it creates a table with a column of datatype: system.decimal I change it to system.int32, but when I use an insert query, the parameter is of decimal format. I changed the type in designer...
    Posted to Oracle (Forum) by nomercy007 on 11-01-2007, 12:00 AM
    Filed under: odp.net, Oracle, Parameters, tableadapter, datatype conversion

  • Re: SqlDataSource, ORA-01008, 01036, and GridView

    Prashant, Thanks for trying to help me. Removing the DeleteParameters did not work. What I ended up doing was removing the OldValuesParameterFormatString. Now it works. Only one or two people are going to be using this application and it's not going to get a lot of modifications once the tables are...
    Posted to Oracle (Forum) by sajala on 07-12-2007, 12:00 AM
    Filed under: Oracle, Parameters, SQLDataSource, VS.2005, and SqlDataSource Control

  • Data Inserting problem

    Hi! I have two tables Address(address_id, street) and Employee(emp_id,address_id,name). // address_id in Employee table is foreign key Here is my stored procedure. CREATE OR REPLACE PROCEDURE address_proc (street in varchar2, name in varchar2) is BEGIN INSERT INTO address VALUES (address_id_seq.nextval...
    Posted to Oracle (Forum) by sthauttam on 05-16-2007, 12:00 AM
    Filed under: Oracle, OracleCommand, Parameters, Stored Proceedures, .net 2.0, c#

  • Re: Help, a big problem worried me for week!!

    Here are a few possible reasons: 1) One of your parameter names might be more than 32 characters long - which causes this error. 2) You've ommitted the : from the front of the parameter names in the parameter collection. 3) You've got a [space] at the end of one of your parameter names 4) You...
    Posted to Oracle (Forum) by Sohnee on 05-14-2007, 12:00 AM
    Filed under: Oracle, Parameters
Page 1 of 1 (6 items)

Contact | Advertise | Ads by BanManPro | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.