To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109041 Issue #|109041 Summary|Acessing PostgreSQL stored procedures not possible wit |h SQL queries and parameters Component|Database access Version|OOO310m19 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|oj Reported by|mbalmer
------- Additional comments from [email protected] Mon Feb 8 13:18:19 +0000 2010 ------- Our database consists of table, views, and a substantial number of stored procedures, especially for the more complex reports and such. E.g, to get the balance of all accounts, you would send the following SQL code to the database: SELECT * FROM acf_balance_all() To get the balance from only on account, you would use SELECT * FROM acf_balance('1000') ('1000' is the account number). When entering the SQL code in the query editor in non-native SQL mode, it outputs a syntax error, i.e. it seems to be unable to handle the PostgreSQL stored procedure calls. One can, however, set the query editor to native SQL mode, then the SQL code is passed as is to the database backend and no error is output. But with native SQL mode, we loose the possibility to have OpenOffice ask the user for parameters. We can only use calls without parameters. But most stored procedurs actually require paramaters. There is a second (and maybe unrelated) problem: OpenOffice Base seems for each query to send a generated query to the database server to check if that table in the query exists. It does something like SELECT COUNT(*) FROM <tablename> WHERE 0 = 1 This will of course never return any data, but it will raise an error if <tablename> does not exist, so I assume this is done to check for the presence of a table. But again, this does not work when a query instead of table specifies a stored procedure in a SELECT. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
