1,488 Topics

Member Avatar for
Member Avatar for b3r1k

can Any one Help me please!! How to make a Procedure can send email with attachment ? thx

0
52
Member Avatar for sandy_b76

Hi, I need to Pass XML File as Parameter to SP and read it and store the tag value in variables. Any example for the same is preferred. Thanks

-1
90
Member Avatar for sandy_b76

Hi, How to check if BLOB field is NULL or Not in a Table though other data is available in a selected row ? I need to do this in a sql statement. Thanks Sandy

Member Avatar for sandy_b76
0
2K
Member Avatar for Joncamp

What is the limit on how many records you can have in a table in Oracle? It must have a limit. Also, has anyone ever benchmarked Oracle on sorting records... say 1,000,000 records of a small record size, just 2 or 3 fields? :cheesy:

Member Avatar for debasisdas
0
3K
Member Avatar for jaeej

How can Stored procedures be used in oracle reports for creating reports instead of SQL queries? Thank you.

0
93
Member Avatar for karan_21584

right now i am studying my final year UG degree. i have developed my project in VB and ORACLE 8i...now i want to execute my project in my college.... now whats the problem is i have to create tables every time in another system.... so i want to bind the …

Member Avatar for rdhiravani
0
72
Member Avatar for kurma
Member Avatar for debasisdas
0
65
Member Avatar for jaeej

Hi, I have few reports which have been created using the Microsoft Sql Server Reporting Services.Now i want to create similar reports using Oracle Reports 10g. Will i need to start from scratch the creation or is there migration tool that would reduce the efforts for the same. Thanks in …

0
74
Member Avatar for Joncamp

Hi, Im installing Oracle 10g on Fedora 5, I did it once, but when I tried to set it up again I got this error on the last part of the install... ORA-12157: TNS: internal network communication error Anybody know what might cause this? I think I have installed all …

0
93
Member Avatar for man_evolution

[B][COLOR=Blue]I've used php mambo and oracle 9 to develop a web-based application..I also used separate server for database and the system..but sometime an error occur to the database connection, its display "Could not connect to database" after submit the data..Anyone can help me out to solve this problem? [/COLOR][/B]

Member Avatar for rbirnale
0
171
Member Avatar for Fungus1487

hello, ive been busy trying over and over and over again to write a block of SQL that will perform this task for me but have failed ever time. hopefully someone can point me in the right direction or at least gime a hand cheers. task : to work out …

Member Avatar for davidcairns
0
121
Member Avatar for nisrin

hello, Im using VB6 and connecting to an Oracle 9i db via ADO. My tables are stored in the SYS folder and am having a problem while accessing these from VB. While connecting to Oracle as username: sys, pswd: change_on_install, the following error message is seen: 'Test connection failed because …

0
67
Member Avatar for Masood Ali

I m using oracle pro compiler to connect to the database and execute dml statement in a C++ program using visual studio 2005. when this procompiler connects to database, it creates a communication area known as sqlca. I have connected a file named test2.cpp, to databse using this compiler. Till …

0
60
Member Avatar for Memento

I hope you can help me with this because I am out of ideas... I am trying to pass a structure [I]into[/I] an Oracle procedure and have had no luck… does anyone know how to pass a complex data type into an Oracle database? My idea was to pass in …

Member Avatar for Memento
0
100
Member Avatar for karan_21584

hai, i m new to this site and my 1st post is this. I have a table which consist of some tuples. i didnt set any primary key. by mistakely i entered the same values for two tuples. i want to delete a single tuple without copying the table to …

Member Avatar for davidcairns
0
109
Member Avatar for websmythe

PopUp Windows I just started with Oracle 10 XE (Express Edition) and found a kool How To on creating PopUp Windows in Application Express [URL]http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html[/URL][URL="http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html"] [/URL]

Member Avatar for websmythe
0
111
Member Avatar for satish.paluvai
Member Avatar for Memento
0
78
Member Avatar for tech291083

Hi, I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow …

0
60
Member Avatar for ultra vires

Is there a way to store multiple enteries in a same field (Like adding delim's..etc , which would be considered while we are firing queries at them) Ex: i have a field named subjects.. is is supposed to have multiple entries in the same field (English , maths ,etc) Is …

Member Avatar for ultra vires
0
157
Member Avatar for stupidenator

Hi everyone, I am still fairly new to SAS programming and I have somewhat of a problem. I am writing a program that will input a Microsoft Excel Spreadsheet and convert it to a SAS dataset. From there, I want to insert everything in that dataset into a table in …

0
94
Member Avatar for tech291083

Hi, I want to learn [URL="http://www.linuxforums.org/forum/redhat-fedora-linux-help/88953-oracle-installation-fedora-core-5-32-bit.html#"]oracle[/URL] on Fedora core 5 32+ bit os that I am using at the moment, but can't not find any useful installation guides (Fedora specific) on the net. Can any one please help me out? Thanks.

0
37
Member Avatar for g.prabu

I am using ORACLE 10G . In EnterpriseManager status of the database is " DOWN" , it shows "DOWN" status last two Days. HOW can I rectify This problem. How to startup my database.

Member Avatar for stymiee
0
81
Member Avatar for Mizu

Hi all :) hehe sorry .. lol 1st of all iam new here :) ... and i really liked this site its very informative :) .. and iam sure i will enjoy being a member here.. before when we do a site we choose the database access but this time …

Member Avatar for jwenting
0
94
Member Avatar for sravani

Hi, I am trying to install oracle 10g ODBC driver in my comp. When I downloaded the oracle10.2.0 version into my comp n unzipped tht exe file.According to readme.txt file in that i should run "product.jar" file in the filelocation .but i could not get that.it consists of only products.xml …

Member Avatar for sravani
0
107
Member Avatar for g.prabu
Member Avatar for nisrin

Im making a site to display reminders set by a client and retrieved from the db (Oracle) using JSP. How can I set the reminders extracted from the db into onto a date displayed in a table cell? Please advice. Thank you.

Member Avatar for jwenting
0
60
Member Avatar for stupidenator

Hi everyone, I am still fairly new to Oracle and SQL. I have two tables with the same information in them. Table1 has the same columns as table2. The differnce between them is the date column. Table1 has 2005 records while table2 has 2006 orders. I am trying to write …

Member Avatar for g.prabu
0
183
Member Avatar for nisrin

A calendar can be created easily in VB..but can the details be stored in Oracle...will it be too complicated? I want to create calendars for different departments and store them in separate tables for a Patient Management system.. Please advice..

Member Avatar for nisrin
0
138
Member Avatar for stupidenator

Hello everyone, I am fairly new to oracle and SQL and I am having a little trouble figuring out how to accomplish a task. I have three columns from a table, we will call them 'a', 'b', and 'id'. I first want to order by 'id' and then query the …

Member Avatar for stupidenator
0
523
Member Avatar for nisrin

hi Excuse me for sounding amateurish, but I need help..Im doing a three tiered architecture proj, is it feasible to use JSP codes to store details about calendars and set reminders with Oracle? Im willing to take up challenges, but Im a novice.. Please advice..

Member Avatar for nisrin
0
93

The End.