Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BJoy
  • Order by date
  1. BJoy

    Geoserver with oracle Geometry data

    Hi, I've created Geoserver Layers using Oracle Geometry Views. The geometry column in the table has been indexed and inserted an entry into USER_SDO_GEOM_METADATA for 27700 SRID reference. while saving the geometry 27700 is added into the geometry details. see the matching coordinates on the...
  2. BJoy

    What’s the best way to do bulk insert in oracle?

    Hi, What is the best way to do bulk insert from c# UI into Oracle database. I tried it passing XML string into oracle (see the below code) but xmltype doesn't accept more than 4000 characters. PROCEDURE UDPATE_NEIGHBOUR_BY_EXTENT(P_XML IN CLOB) AS v_today date :=SYSDATE; BEGIN FOR item IN (...
  3. BJoy

    Bulk insert from C# into Oracle Database

    Hi, What is the best way to do bulk insert from c# UI into Oracle database. I tried it passing XML string into oracle (see the below code) but xmltype doesn't accept more than 4000 characters. PROCEDURE UDPATE_NEIGHBOUR_BY_EXTENT(P_XML IN CLOB) AS v_today date :=SYSDATE; BEGIN FOR item IN (...
  4. BJoy

    How can I read XML data in Oracle.

    Hi, I'm new to oracle and would like to know how can I read XML in oracle like SQL SERVER Query. I know how I can do it in SQL Server (see the below code). Would anyone be able to help me out please? declare @XMLDoc xml set @XMLDoc = ' <list> <item uprn="64333" address="abcd" /> <item...

Part and Inventory Search

Back
Top