Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0037318 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] Z. Others | minor | always | 2017-11-17 10:30 | 2024-05-28 10:45 | |||||||
| Reporter | jainsapna581 | View Status | public | |||||||||
| Assigned To | Triage Platform Base | |||||||||||
| Priority | urgent | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Windows | Database | PostgreSQL | Java version | 8 | |||||||
| OS Version | 7 | Database version | 9.3 | Ant version | 1.9.7 | |||||||
| Product Version | 3.0PR17Q1.1 | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| Web browser | Google Chrome | |||||||||||
| Modules | My Openbravo Tab | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0037318: function which returns table | |||||||||||
| Description | We are creating a function which returns table and able to export and package it in functional state. But when we install this module, we get below error for the procedure and procedure does not get created. [java] 55489 WARN - SQL Command failed with: ERROR: cannot use RETURN QUERY in a non-SETOF function [java] Position: 1596 [java] 55497 WARN - -- END [java] -- ----------------------------------------------------------------------- [java] -- FUNCTION API_GETDATA [java] -- ----------------------------------------------------------------- [java] CREATE OR REPLACE FUNCTION API_GETDATA(pcs OUT NUMERIC, quantity OUT NUMERIC) [java] Is there any way or alternative for such procedures where we need to return a table from procedures | |||||||||||
| Steps To Reproduce | 1. Create the below function CREATE OR REPLACE FUNCTION api_getdata() RETURNS TABLE(pcs integer, quantity integer) AS $BODY$ /******************************************************************************/ BEGIN RETURN QUERY select count(*) as pcs,round(qtyonhand,2) as quantity from api_data; END ; $BODY$ LANGUAGE plpgsql VOLATILE 2. package it and install in other environment | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-11-17 10:30 | jainsapna581 | New Issue | |
| 2017-11-17 10:30 | jainsapna581 | Assigned To | => Triage Finance |
| 2017-11-17 10:30 | jainsapna581 | Web browser | => Google Chrome |
| 2017-11-17 10:30 | jainsapna581 | Modules | => My Openbravo Tab |
| 2017-11-17 10:30 | jainsapna581 | Regression level | => Packaging and release |
| 2017-11-17 10:30 | jainsapna581 | Triggers an Emergency Pack | => No |
| 2023-04-29 01:33 | axelmercado | Relationship added | causes 0052297 |
| 2023-05-02 09:24 | aferraz | Assigned To | Triage Omni OMS => Triage Platform Base |
| 2024-05-08 12:50 | alostale | Web browser | Google Chrome => Google Chrome |
| 2024-05-08 12:50 | alostale | Severity | critical => minor |
| 2024-05-08 12:50 | alostale | Type | defect => feature request |
| 2024-05-28 10:45 | alostale | Web browser | Google Chrome => Google Chrome |
| 2024-05-28 10:45 | alostale | Regression level | Packaging and release => |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |