Hello!
I'm trying to fix an appliaction created using ColdFusion MX and Oracle 9i. The application worked fine until our IT department reinstalled the oracle server. As far as I've been able to see.
The CF application calls to a stored procedure in a package on the Oracle server. However, when the CF application attempts invoce the stored procedure, I get the following error message:
PLS-00306 wrong number or types of arguments in call to 'string'
We haven't changed anything in either the stored procedures or the application. Anyone have any ideas as to what the problem might be? I've included the procedures and the relevant CF code below.
(The application is available at http://nordbotten.ifi. uib.no/VirtualMuseum/Prototypes/Osdal3/index.cfm)
----
(PACKAGE BODY VTX)
PROCEDURE proc_vtx_search (
url IN VARCHAR2,
filename IN VARCHAR2,
shape IN VARCHAR2,
color IN VARCHAR2,
texture IN VARCHAR2,
spatial IN VARCHAR2,
threshold IN VARCHAR2,
images OUT typ_vtx_result)
AS
-- declarations
result VARCHAR2(1000) := NULL;
seed_number NUMBER := 1;
weights VARCHAR2(1000);
results_null EXCEPTION;
no_insert EXCEPTION;
BEGIN
test_insert_see d(url, filename, seed_number);
IF seed_number = -1 THEN
RAISE no_insert;
END IF;
weights := 'color = "'||color|| '" texture = "'||texture ||'" shape = "'||shape|| '" location = "'||spatial||'" ';
result := vtx_fct_search( seed_number, weights, threshold);
IF result IS NULL THEN
RAISE results_null;
END IF;
OPEN images FOR SELECT result AS images FROM dual;
EXCEPTION
WHEN results_null THEN
result := '-1';
WHEN no_insert THEN
result := '-2';
WHEN OTHERS THEN
result := '-3';
END proc_vtx_search ;
END vtx;
---------
Relevant Coldfusion code:
<cfstoredproc datasource="#Ap plication.db_od bc#" procedure="vtx. proc_vtx_search " returncode="no" >
<cfprocparam type="in" value="#Applica tion.server_add ress##Applicati on.uploads_path #" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#Session .image#" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#shape#" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#color#" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#texture #" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#spatial _structure#" cfsqltype="cf_s ql_varchar">
<cfprocparam type="in" value="#thresho ld#" cfsqltype="cf_s ql_numeric">
<cfprocresult name="images_re sult">
</cfstoredproc>
0 1667 Sign in to post your reply or Sign up for a free account.
Similar topics |
by: susmita_ganguly |
last post by:
Hi
I am trying to upgrade from oracle 8i to oracle 9i on the same server
..I don't know much abt migration .
Can anyone help me out.
Thanks.
Susmita
|
by: Rhino |
last post by:
One of my friends, Scott, is a consultant who doesn't currently have
newsgroup access so I am asking these questions for him. I'll be telling him
how to monitor the answers via Google Newsgroup searches.
Scott has heard a lot of hype about DB2 and Oracle and is trying to
understand the pros and cons of each product. I'm quite familiar with DB2
but have never used Oracle so I can't make any meaningful comparisons for
him. He does not have...
|
by: Girish |
last post by:
Hi all,
We are doing an exercise of migrating an application (developed in
Informix 4gl) from Informix to Oracle database.
Before doing actual migration, we would like to know some of the key
advantages of Oracle over Informix. If there are any examples of any
company getting benefits because of this kind of migration, please
reply me such kind of case studies.
Please reply to my email id.
|
by: jonathan |
last post by:
hey all,
I realize that this question might pop up from time to time, but I
haven't seen it a while and things might of changed, so -
Right now (July 2004) how does mysql stand up in comparison to oracle?
We are seriously considering migrating our multi-processor oracle
system to mysql to save on licensing costs, and would need several
features that mysql may or may not have:
|
by: Chris Botha |
last post by:
The machine is running XP Pro with all the latest service packs, etc. I must
access an Oracle database so I installed the Oracle client stuff. I can
query Oracle from a Windows app, no problem. Using the exact same code (copy
and paste) into a Web app I get the following error "Error while trying to
retrieve text for error ORA-01019". Security I thought, so I use
Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
| |
by: kc7zdm |
last post by:
I'm using Oracle intermedia text indices in my database, and the Contains function from a VB.Net program using the system.data.oracleclient provider. When a query includes a number as a search term, it returns zero rows, throws no error when run from the program. The same query run from Toad or SQLPlus properly returns 2 rows as expected. I can't find anything on this in any of the documentation. Has anyone seen this? Any help will be...
|
by: marcnz |
last post by:
I have been charged of creating a coldfusion web site for our company.
Our database has a ms sql 2005 backend and ms access frontend. Almost all tables are linked tables with the SQL database, except the temp tables needed at runtime that are in the ms access database.
It will be easier for us to utilize the ms access queries and temp tables, so I set up a datasource on our web server and within the coldfusion administrator to point to the ms...
|
by: SAL |
last post by:
Hopefully someone will have a clue as to what is happening here. In our
office, we have both ColdFusion and ASP.NET applications. One of our new
developers has been installing ColdFusion 8 on the servers and after the
install, a couple of my apps have been unreachable. IIS would report the NOT
Found error. The folders would still be there and it would still look like
it was an application viewing it in IIS. You just couldn't reach the app...
|
by: dmorand |
last post by:
I'm using Coldfusion MX7, but I don't see an Oracle datasource in my coldfusion administrator. I've looked around trying to figure out how to get an Oracle datasource loaded so I can query Oracle db's, but can't find any info on how to get this working.
Does anyone know how to do this or point me in the right direction??
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |