On 24 Oct 2011, at 14:24, <Mamatha_Kagathi_Chan@DELL.com> wrote:
> Hi ,
>
> I have migrated Sql Server 2005 database to PostgreSQL 9.0 . I was also successfully able to connect classic ASP to
themigrated database. But when the page reaches a stage where it is accessing a procedure I get the following error.
>
> PostgreSQL Native Provider error '80040e14'
>
> ERROR: syntax error at or near "' 789500'" LINE 1: EXEC Visadetailinsert ' 789500','No','Select visa','','','Se... ^
>
> /postgresql/EmployeeDetails.asp, line 645
Is that a line in a plpgsql procedure? It looks like you're trying to call a function, but your syntax is entirely
wrong.
You probably want to read up on:
http://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/PostgreSQL_x20238_004.htm
Curiously enough the rather fine manual isn't very verbose on this subject. In the 9.2-devel docs there is even a
sectionnamed "Calling functions", but it seems to focus on writing functions instead.
Alban Hertroys
--
The scale of a problem often equals the size of an ego.