Hi, I have a SP calling another SP with input and output Parameters. But the child SP doesn’t pass back the Ouput Parameters to the first SP CREATE OR REPLACE PROCEDURE SP_SAT_PERSON_GC () DYNAMIC RESULT SETS 1 LANGUAGE SQL P1: Continue reading sotred procedure calling another stored procedure
Hi, I m getting issue regarding the Oracle Application in production,The menu navigator is being hidden. Thanks Rahul
Hello, I have the following stored procedure but the error variables are not populated with the output error code. In my case it should abort for duplicates , if I execute the SQL I have the folling error messages –One Continue reading SQLSTATE and SQLCODE not correctly filled in a Stored Procedure
have this update statement that works for one record. How do I write it to include multiple records at once. Please see sample below. update mklopt set FRMDAT = ’12/31/2014′ where JOBCOD = ‘PH14789’ I also want to include the Continue reading update statement inclusion
Hi all — I’ve been scouring the web for a web-based editor client for a cloud MySQL database that we’re about to put into production in the new future. The issue is that we have a bunch of people on Continue reading MySQL Web-based Client with spreadsheet capabilities?
Hi there, I’ve been working on several triggers and always have this msg : Code: “Warning: Trigger created with compilation errors.” I dunno why, here’s one of the triggers that gives that msg : Code: CREATE OR REPLACE TRIGGER CityExists Continue reading Creating trigger but having a "Warning: Trigger created with compilation errors."
Hello I have a table similar to the next: CODE | AMOUNT1 | AMOUNT2 | LOAD_DATE | 2013-XX-ZZ | 500 | 200 | 2015/04/04 | 2013-XX-ZZ | 300 | 200 | 2015/04/04 | 2013-XX-ZZ | 600 | 100 | 2015/03/01 Continue reading Sumarize two rows values based on 2 most recent dates
Draggo is a New FREE Service to Organize and Access All Your Personal Links On a Single Page. Why Use Draggo? It’s Free. Create Your Own Draggo. It’s Easy. Drag & Drop Links in a Snap! It’s Useful. Save, Organize Continue reading Draggo – Great With Any Developmer’s Toolbelt
Hello Everyone, Need some helps regarding archive replication in PostgreSql.I am not very old in PG…days back i have configured a replication setup via archive streaming for our Production Database. Earlier to this the setup was already configured as ‘hot_standby’ Continue reading PG Archive Streaming
Hi All I have a database which is currently running in Postgresql 8.3 and I am wishing to upgrade it to the latest Postgresql version ~9.3 I have read that “ Upgrading from PostgreSQL 8.3 has additional restrictions not present Continue reading PG upgradation from 8.3 to 9.3