[HACKERS] Query

2007-09-21 Thread Eswar
Hi I have just installed PostgreSQL 8.1 on a Windows XP system with a NTFS filesystem. Everything seemed to work fine until I executed the command promt option from the PostgreSQL start button. I wanted to create my first database by typing "createdb mydb" and was asked for my password. Ev

[HACKERS] Oracle to PostGre

2017-11-01 Thread Brahmam Eswar
Hi, App is moving to Postgre from Oracel . After migrating the store procedure is throwing an error with collection type. *Oracle :* create or replace PROCEDURE"PROC1" ( , REQ_CURR_CODE IN VARCHAR2 , IS_VALID OUT VARCHAR2 , ERROR_MSG OUT VARCHAR2 ) AS TYPE INV_LINES_RT IS RECORD(