472,983 Members | 2,361 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,983 software developers and data experts.

Unable to identify a function that satisfies the given argument types

Why do I keep getting this error in the function to insert data below,
any help would be apprecaited:

CREATE OR REPLACE FUNCTION public.add_apppointment (date, time,
integer,time, boolean, text, integer, integer, varchar, integer,
boolean, varchar, varchar[], integer[]) RETURNS text AS'
v_appt_date date ;
v_end_time time;
v_appt_duration int2;
v_start_time time;
v_canceled_flag boolean;
v_memo text;
v_start_slot_id int2;
v_end_slot_id int2;
v_room_id varchar;
v_patient_id int4;
v_out_of_town boolean;
v_procedure_cd varchar;
v_ancillary_proc varchar[];
v_practitioner_id int4[];

v_patient_name text;
v_pat_phone text;

v_status text;

v_appt_date = $1 ;
v_end_time = $2;
v_appt_duration $3;
v_start_time = $4;
v_canceled_flag = $5;
v_memo = $6;
v_start_slot_id = $7;
v_end_slot_id = $8;
v_room_id = $9;
v_patient_id = $10;
v_out_of_town = $11;
v_procedure_cd = $12;
v_ancillary_proc = $13;
v_practitioner_id = $14;

v_pat_phone := cast (get_phone(v_patient_id) as varchar);
v_patient_name := get_name(v_patient_id);
insert into appointment values(default,
$1 ,
$5 ,
$14) ;

return v_status;

ERROR: Function add_appointment(date, time without time zone,
smallint, time without time zone, boolean, text, smallint, smallint,
character varying, integer, boolean, character varying, character
varying[], integer[]) does not exist
Unable to identify a function that satisfies the given
argument types
You may need to add explicit typecasts


Ayokunle Giwa
Jul 19 '05 #1
1 6646
On 4 Mar 2004 15:57:31 -0800, Ayokunle Giwa <ag***@cox.net> wrote:
CREATE OR REPLACE FUNCTION public.add_apppointment (date, time, ERROR: Function add_appointment(date, time without time zone,

See the subtle difference? apppointment/appointment

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: nikola | last post by:
Hi all, I was working with a simple function template to find the min of two values. But since I would like the two values to be different (type) I dont know what kind of value (type) it will...
by: Ben | last post by:
Hi, there. Recently I was working on a problem where we want to save generic closures in a data structure (a vector). The closure should work for any data type and any method with pre-defined...
by: Kapt. Boogschutter | last post by:
I'm trying to create a function that has at least 1 Argument but can also contain any number of Arguments (except 0 because my function would have no meaning for 0 argument). The arguments...
by: Randell D. | last post by:
Folks, I'm sure this can be done legally, and not thru tricks of the trade - I hope someone can help. I'm writing a 'tool' (a function) which can be used generically in any of my projects. ...
by: Marek Lewczuk | last post by:
Hello, I'm moving out from MySQL to PostgreSQL and there are some function which are not supported in PG so I'm trying to write my own functions. Currently I have big problem with function IF(),...
by: Mike Leahy | last post by:
Okay.I'm following the documentation that came with the PostgreSQL source code (located in /usr/doc/postgresql-7.3.4-2/html/arrays.hmtl in my cygwin root). I created have a table with a varchar...
by: Richard Hengeveld | last post by:
Hi all, I'm trying to understand how pointers for function parameters work. As I understand it, if you got a function like: void f(int *i) { *i = 0; }
by: clintonG | last post by:
I can't tell you how frustrated I get when going to a web developer's website and observing he or she is an idiot that has not grasped the most fundamental element of usability: page title naming...
by: souporpower | last post by:
Hello All I am trying to activate a link using Jquery. Here is my code; <html> <head> <script type="text/javascript" src="../../resources/js/ jquery-1.2.6.js"</script> <script...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.