Browse by Tags

Related Posts

  • Select statement for arabic data not working!!

    Hi, In my asp.net code, I am trying to retrieve some data from an oracle database using a select statement that includes an arabic string (see in green). The select statement is as follows: select * from T_GOG_PHONEBOOK where afl_name like '%عبدالله جابر%' and rownum < 50 For some reason,...
    Posted to Oracle (Forum) by cpcdafoor on 07-28-2008, 12:00 AM
    Filed under: Oracle, .net, c#, asp.net, how to convert a .net date to oracle date
  • oracle dataset parser error-Failed to generate code. Exception of type 'System.Data.Design.InternalException'

    I created a web apllication in asp.net 2.0 and c#. I created a virtual directory for this app in a dev- environment. every thing works fine in dev. I moved the same code to a virtual directory in test environment that is integrated with -OAM(oracle access management).I recieve the following error.I appreciate...
    Posted to Oracle (Forum) by kirang_97 on 07-21-2008, 12:00 AM
    Filed under: ODP.NET Oracle, Oracle, Oracle Databases, c#, data access, asp.net, asp.net 2.0
  • How can i call a Oracle Function which return value is user defined record? SOS !!!!!

    Package and Function: SPEC CREATE OR REPLACE PACKAGE PACKAGE_SUHUATEST AS type resp is record (resp_key varchar(30), app_name varchar2(15)); type resp_tab is table of resp INDEX BY BINARY_INTEGER; FUNCTION MyFunction(invar in varchar) return resp_tab ; END PACKAGE_SUHUATEST; / BODY CREATE OR REPLACE...
    Posted to Oracle (Forum) by suhua on 05-30-2008, 12:00 AM
    Filed under: Oracle, oracle procedure C#, Stored Proceedures, .net 2.0, c#
  • regarding connection pooling in oracle for my .net application

    actually we are using microsoft entireprise library for connecting to sql server database which is giving good performance for my application.Here I had a problem for my new application where I am using Oracle database as back end.To increase the performance of my application which library I need to...
    Posted to Oracle (Forum) by shivarlakrishna on 05-12-2008, 12:00 AM
    Filed under: Oracle, oracle PL/SQL parameters excetion handling, OracleCommand, oracleconnection, VS.2005, .net 2.0, asp.net 2.0, c#, data access, web.config
  • Manipulate the data returned from database query

    Hi, I am new to APS.NET and programming in general and was looking for some help. I am using ASP.NET 2.0 and C# with an Oracle 10g Express Edition database behind my application. What I am trying to do is retrieve the last 10 entries in the database (I know the SQL to do this) but would like some help...
    Posted to Oracle (Forum) by asp.newtome on 05-08-2008, 12:00 AM
    Filed under: Oracle, sql query, .net 2.0, asp.net, asp.net 2.0, c#
  • Insert not inserting to Oracle db

    Hi, I am just trying to learn ASP.NET but have run into a problem when attempting to insert data into my database. I am using Oracle 10g Express Edition, Visual Studio 2005 and the code is in C#. Here is the code I am using to call the insert statement; string sql = "INSERT INTO offices (office_number...
    Posted to Oracle (Forum) by asp.newtome on 04-23-2008, 12:00 AM
    Filed under: Oracle, Oracle Package, oracle PL/SQL parameters, oracle procedure C#, Oracle Stored Procedures Package SqlDataSource Bind Parameters, OracleCommand, oracleconnection, sql query, VS.2005, asp.net, c#, ConnectionString, data access, insert multiple attachments into Oracle
  • Uploading and Downloading Binary File(PDF) from Oracle Using C# Command Line

    I'm in the process of creating a small command line application that will write and retrieve PDF's to an Oracle BLOB field. Currently I am working on the "writing" part. I did a bit of Googling and couldn't really find an example if doing this from the command line, everything was...
    Posted to Oracle (Forum) by Sojan80 on 03-20-2008, 12:00 AM
    Filed under: Oracle, Retrieving files, Uploading Files, Binary Files, c#, Command Line
  • How to update data returned using REF CURSOR

    Hi all, I am trying to update updated data in a gridview but the update button seem to do nothing as i retreive data using REF CURSOR. Let me describe the architecture of my application first. I'm trying to implement best practice whenever possible. I am following the data access tutorial published...
    Posted to Oracle (Forum) by imanour on 03-10-2008, 12:00 AM
    Filed under: Oracle, Oracle Package, Ref Cursors, VS.2005, .net 2.0, ado.net, c#, Using REF cusror with ADO.net, asp.net 2.0, dataset
  • Re: Converting Now date to Oracle's whacky date

    Date .Now.ToString( "yyyy-MMM-dd" ) doesnt make sense but works. You can also try Date .Now.ToString( "dd-MMM-yyyy" ) universal function to convert any oracle date to .net date to_char(doe,'MM-DD-YYYY HH24:MI:SS')= '" & doe.ToString( "MM-dd-yyyy HH:mm:ss"...
    Posted to Oracle (Forum) by ratnamadhuri on 12-14-2007, 12:00 AM
    Filed under: Oracle, vb.net, .net, c#, conversion, convert now date to oracle date, date, function, time, how to convert a .net date to oracle date
  • Inserting Data into multiple tables in Oracle Database by pressing single "Insert" button in FormView

    Hi,I am totally new in ASP.NET.I have a query which may be very foolish to all of you but despite I'll be really thankfull if I get the answer urgently. PROBLEM: described in following steps... 1) I have 3 tables in database A) employees : containing columns :: (emp_code,emp_name,dept) B) emp_prof_qualifications...
    Posted to Oracle (Forum) by Tapamay on 08-17-2007, 12:00 AM
    Filed under: Oracle, VS.2005, and SqlDataSource Control, c#, asp.net 2.0
Page 1 of 3 (25 items) 1 2 3 Next >