Home » Server Options » Text & interMedia » ordAudio
ordAudio [message #242035] Thu, 31 May 2007 08:04 Go to next message
federicaintermedia
Messages: 6
Registered: May 2007
Junior Member
Hi all.
i would like to create a table with object ORDAudio as BFile, but i don't know how.can somebody post an example code??
thanks in advance
Re: ordAudio [message #242197 is a reply to message #242035] Fri, 01 June 2007 00:36 Go to previous message
Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA
Senior Member
scott@ORA92> CREATE OR REPLACE DIRECTORY your_dir AS 'd:\oracle2'
  2  /

Directory created.

scott@ORA92> CREATE TABLE your_tab
  2    (id	    NUMBER,
  3  	your_bfile  ORDSYS.ORDAUDIO)
  4  /

Table created.

scott@ORA92> INSERT INTO your_tab (id, your_bfile)
  2  VALUES (1, ORDSYS.ORDAudio.init ('FILE', 'FILE_DIR', 'speaker.au'))
  3  /

1 row created.

scott@ORA92> SELECT COUNT (*) FROM your_tab
  2  /

  COUNT(*)
----------
         1

scott@ORA92> 

Previous Topic: oracle intermedia
Next Topic: Summarizing multiple documents
Goto Forum:
  


Current Time: Thu Nov 21 10:24:15 CST 2024