Oracle

• Oracle Questions

• • How to make workflow refer to the latest version o...

    I am using Oracle Workflow 2.6 with Oracle 9iAS on Oracle d/b 8.1.7 on Unix.I am having a situation ...

    By satishhatti

  • how to make the backup database for the running da...

    Ladies and Gentlemen: who can teach me that how to make a backup database for the running database? ...

    By developer

  • Recomendations for strip size in a RAID 5 envirome...

    Customer is currently invoking a RAID 5 disk array. Application is Multi-Master Advanced Replication...

    By jmihuc

  • How to make the connection between 8i and ASP

    I could not how to make the connection between 8i and ASP. Is it need to type some script? Please to...

    By developer

  • external procedure calls--ORA-03113

    Hi All, i tried to install Oracle Text with 9i database. these r the entries in the listener.ora and...

    By kiransshetty

• • How to make the database web enabled

    HelloI have installed oracle 8i database on windows 2000 OS and I have the oracle 8i WEBDB cd also.I...

    By user583327, 2 Comments

  • "- -" OR "/ *""* /" Commen...

    Its been a couple of years since working with pl and sqlbut one thing that hasn't changed i...

    By user568207, 3 Comments

  • how to manage image without save it on db

    dear all,my goal is don't store image into db but only save the path that ponit to them in a db...

    By user594851, 2 Comments

  • How to make this searching form

    Hi guys,I want to create a canvas with two blocks.The first one is made by 4 text-items where the us...

    By salvo, 3 Comments

  • Oracle 8i install problem

    Hello, I had to remove Oracle 9i from my winxp home machine. I would like to install Ora 8i on this ...

    By wootenja, 3 Comments

• Oracle: is the Category's subject.It's has 386 questions,this is No.20 pages.
• BLOB vs. CLOB
• I am creating an application that will store and search documents in various languages in an Oracle 9i database.Should I use BLOB or CLOB to store the documents?Does Oracle Text care either way?Advantages/disadvantages of either?...
• sxhans, Sun, 14 Mar 2010 14:05:00 GMT, 245 bytes
• Oracle 8i Installation
• Hi Dear Friends......... I need your assistance regarding Oracle 8i installation.Oracle Universal Installer is not runing on my PC...... It works fine on my friend's PC. What Should I do.Please help me out of this problemLooking Forward,Jazil Mahmood Butt...
• jazilbutt_hotma_, Sun, 14 Mar 2010 13:30:00 GMT, 280 bytes
• HELP ME! Could you guide to me some problem about GeoRaster!
• Hi everybody!I have some problem with GeoRaster:- First, My Image (570,760). I do not know BottonLep&TopLeft and BottomRight and TopRight.I do not know MBR for Image also I do now know device blocksize suitable and MBR of each Block.How I device PyramidLevel suitalbe. If I do not device Pyra...
• yumi, Sun, 14 Mar 2010 10:23:00 GMT, 659 bytes
• BLOB to File
• 9i and up - Anyway to get a 4 mb & up BLOB to file on disk ?UTL_FILE error:blob length:3967200 error in PUT_LOCAL_BINARY_DATAORA-29285: file write errorso UTL_FILE is out of the questionthanks...
• robert, Sat, 13 Mar 2010 15:35:00 GMT, 228 bytes, 9 Answer
• BLOB Upload via ASP ORA-00600 Error
• I have a routine that successfully uploads a file into a blob field of a table via ASP. Yet, approximately once a day (and it seems to be on the first attempt of upload each day), the routine returns an error. I have gotten these errors with all file types and sizes and can usually reproduce it...
• ryan_bolchoz_ur_, Sat, 13 Mar 2010 15:01:00 GMT, 782 bytes, 1 Answer
• External procedure
• I want to invoke from PL/SQL (VfmVerify and VfmCreate) functions that exists on DLL.How can I invoke p.e. function VfmCreate(&matcher) from PL/SQL? Can I do that? matcher is of type HVFMatcher but the argumet is just a reference to matcher.And about define object types that exists on C++ but...
• user504347, Sat, 13 Mar 2010 15:01:00 GMT, 1,744 bytes, 2 Answer
• Blob size?
• Hello, I am new to oracle and I need some help.We have a software that acquires labotory data and store it in a blob column of a table. Is there a function that returns a physical size (mb, kb) of a particular image file stored in the blob column?I've looked at user_tables and user_tab_colu...
• hclee_shimadzu, Sat, 13 Mar 2010 05:23:00 GMT, 354 bytes, 2 Answer
• Oracle 8i installation error
• I am installing Oracle 8i on windows 2000 pentium IIImachine. I selected minimal installation option with nostartup database creation. I get following error.Error in writing to filec:\oracle\ora81\jlib\swingall.jarpress help Retry cancelWhen I press cancel it proceeds with installation andgives...
• kkk786, Sat, 13 Mar 2010 03:31:00 GMT, 466 bytes
• external procedure returning CLOB
• Hi,I am looking for a good example of a C external procedure returning a CLOB. My database is 8.1.7.3. I searched both Metalink and OTN, but couldn't find anything (apart from one posting describing a problem with CLOBs vs BLOBs).Any help will be much appreciated.Regards,Plamen...
• plamen2, Sat, 13 Mar 2010 03:31:00 GMT, 307 bytes
• How to make this function in Oracle
• CREATE OR REPLACE FUNCTION f_looking (car.car_ID%TYPE) RETURNS void AS ' DECLAREcar ALIAS FOR $1;person person.person_ID%TYPE;username VARCHAR(20);sqlstring TEXT;hel pinteger;help2 integer;lenghtx integer;BEGIN username:=current_user; help:=strpos(kasutajanimi,''_''); he...
• markotek, Sat, 13 Mar 2010 03:31:00 GMT, 780 bytes, 1 Answer
• Blob size question
• I have tried loading 2 image file, total of 100kb but when i checked the bytes it occupied 2Mb. Is there a minimum size of a BLOB data type? This is how i checked the bytes occupied./* -- BEFORE LOADING -- dba_segments */SUBSTR(SEGMENT_ BYTES INITIAL_EX NEXT_EXTEN-- -- -- --BLOBTEST 163840 13107...
• reimon, Sat, 13 Mar 2010 03:31:00 GMT, 847 bytes, 1 Answer
• blob size
• hi,i'm trying to insert a file in a blob field, but the maximum size of this field is 4 kb, how can i increase the size of the field to 1Mb?thanks...
• jessica, Sat, 13 Mar 2010 03:31:00 GMT, 159 bytes, 2 Answer
• Data Migration from SQL to Oracle
• Hello All,We have two applications, one made in SQL and the other made in Oracle. The users enter data in the application developed in SQL and at the end of the day they have to upload all their data into Oracle. We have to give a connector between both the applications so that at the end of the...
• era_agarwal_yah_, Sat, 13 Mar 2010 03:28:00 GMT, 447 bytes, 1 Answer
• Data migration from SQL Server to Oracle
• Hi All,We are working on data migration from SQL Server to Oracle. I'm getting a dump from SQL Server using BCP and loading it into Oracle using SQLLDR.SQL Server distinguishes between null and blank string so BCP puts "\0' character as substitute for blank string in the outfile. SQLLD...
• vinodp, Sat, 13 Mar 2010 03:19:00 GMT, 769 bytes, 2 Answer
• External Procedure
• We have set up an external procedure that uses c code. When trying to use we get the error message "lost RPC connection". We can't seem to figure out what we are doing wrong and if anyone could help it would be appreciated.Peter...
• developer, Sat, 13 Mar 2010 00:41:00 GMT, 237 bytes, 1 Answer
• BLOB size matters
• Hello, Well, I'm working on a mid-size project where huge amount of maps (images) should be stored inside blob column, successfully we inserted a mass records into the table using plsql block. my question is I noticed images size were changed after inserting from 1000 KB to 1050 KB for exam...
• mj, Fri, 12 Mar 2010 22:56:00 GMT, 369 bytes, 1 Answer
• Oracle 8i installation
• Whenever i install oracle 8i on pentium 4 machine ,the installer is not coming up ?why is this happening?Even i update Oraparam and then i change jre even then it does not start and if it starts database is not starting up?...
• arif_sibhai, Fri, 12 Mar 2010 18:50:00 GMT, 224 bytes, 1 Answer
• External procedure with Pro*C code in it
• I have some C functions that I have compiled into a shared library on Unix.One of the functions contains a SQL statement to insert into a table, so Icompile the file with Pro*C. It compiles fine. I have another C programthat calls the function within my shared library. It runs fine and the share...
• developer, Fri, 12 Mar 2010 18:10:00 GMT, 1,192 bytes
• DOWNLOAD THE MOST POPULAR 2005's CRACKED SOFTWARE(CAD/CAE/CAM/EDA/GIS/PCB/FEA/CNC/
• Our Team provide CRACKED engineering and technical software at this topics:=> Civil and Structural=> Survey , GIS , Rock , Soil and Water=> Architectural=> CAD-CAM=> FEA , CFD and CAE=> Electrical , Electronic , Control and Power=> Chemical=> Industrial and Control Projec...
• guest, Fri, 12 Mar 2010 16:26:00 GMT, 9,276 bytes
• how to make the page disabled or unvisible with specific password ?
• I am student. I need your help in my assignment.I have 2 main page called = call problem and call report. The call problem page only can access by operator and call report page only can access by manager with the specific paasword.Did any body know how to disabled or invisible the page with the...
• user544509, Fri, 12 Mar 2010 04:24:00 GMT, 380 bytes, 1 Answer
• «««1011121314151617181920