× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Vaibhav Laddha
vaibhavladdha271(*) reported Feb 12, 2014  · tariqrahiman last modified Sep 26, 2014

Unable to drop procedures containing varchar or char datatype as parameter in Informix 12.1


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - ER Modeler
Version 16.0

Aqua Data Studio 15.0.0-dev-96
Build #: 35893
Built on: 2014-Feb-06 02:45:16 PM     

Database: Informix 12.1

Operating environment: Windows 7 x64

Connect to Informix

Create a table named 'customer'

Create table script:

CREATE TABLE informix.customer  ( 
customer_num SERIAL NOT NULL,
fname       CHAR(15),
lname       CHAR(15),
company     CHAR(20),
address1     CHAR(20),
address2     CHAR(20),
city         CHAR(15),
state       CHAR(2),
zipcode     CHAR(5),
phone       CHAR(18),
PRIMARY KEY(customer_num)
ENABLED
)
LOCK MODE PAGE
GO
 

Create a procedure named 'read_address'

Create procedure script:

CREATE PROCEDURE informix.read_address(lastname CHAR(15))
RETURNING CHAR(15),CHAR(15);
 
DEFINE p_lname,p_fname CHAR(15);
 
SELECT fname,lname INTO p_fname,p_lname FROM customer WHERE lname = lastname;
 
RETURN p_fname, p_lname;
END PROCEDURE
GO
 
Right click on created procedure 
Select drop procedure
It shows an error message:
'A syntax error has occurred'
 
Same error occurs when we try to run drop procedure script through query analyzer window
 
 
 
1 attachment
  •  
  •  
  • No shares
  •  
All Comments Change History (3)
Sort 
Niels Gron
NielsGron   Jun 23, 2014
Field Old Value New Value
Version 15.0 15.1
Niels Gron
NielsGron   Aug 22, 2014
Field Old Value New Value
Version 15.1 16.0
Tariq Rahiman
tariqrahiman   Sep 26, 2014
Field Old Value New Value
Resolution Fixed
Resolved Date Sep 26, 2014 10:52 PM
Status New Closed

Issue #11702
Closed
Fixed
Resolved Sep 26, 2014
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017