Postgres

[Richard Douglass]

I am trying to make a procedure call to a Postgres database and it keeps
giving me an invalid comment.

if I pass "SELECT * FROM TheTable" it works just fine

if I pass "EXEC GetTheRecords" which just does that same select...it bombs

any ideas?

 

[Patrick Molloy]

is the security level of the stored procedure correct?

 

[Richard Douglass]

It was compiled using the DBA account.

I am not entirely sure though.