Sitemap

Amicuk Programming Answers

How can we update procedure in Database Directly

2015-10-11   Views:0

Advertisement

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W

Hi Experts
how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that When I run the report It automatically create stored procedure . or other simple way to create stored procedure
Regards
Gorge
Edited by: Gorge Ance on May 13, 2009 8:09 AM

The replay answer
Advertisement
Hi
If your field match what you have in demo and production ,all you need to do is run that stored procedure pointing to correct database .So you probable have to change alter to create .
When you go to sql server , you have a choice to run a query of stored procedure  against the particular dtabase while you use query analyser .
In crystal report , you have to manually change the datasource and update store procedure.
Your report will now point to production database and point to correct stored procedure .
Hope this helps
Bishal

Go to See the other 4 answers

How can we update procedure in Database Directly

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts how can we create a stored procedure in a database directly. for example I made a crystal report with a demo databse, then I want to run that report on production database. for that I have to create stored procedure manually. I want that W[More]

Update procedure from APEX 3.1 to 3.1.2 on Oracle XE database

Category:DefaultRelease time:-0001-11-30Views:130

Hello, how to make an update of APEX 3.1 to 3.1.2 on an Oracle XE database with the full installation pack (which you get normally at OTN)? I mean the patchset 7313609 from Metalink wont work on a XE database because it doesn't have the opatch featur[More]

Block with more than one table type agurment -  Update Procedure for Block

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have one form with 3 Block. First Block is single row block, and other 2 are details block . The details balocks are based on the Procedure datasource, because of the complex query conditions. Now my requirement is When Inserting / Updating the[More]

U430 BIOS Update Procedure (fixes wake from sleep issue on Windows 8.1)

Category:DefaultRelease time:2015-10-11Views:130

Hopefully this will make the BIOS update process a bit easier.  The following steps address two common questions (Failed BIOS Update and the Windows message about improperly configured Secure Boot).  NOTE: After a successful BIOS update you will want[More]

Error Stored Procedure Upgrading database from SBO 2007A PL42 to SBO 8.8

Category:DefaultRelease time:2015-10-11Views:130

Hi, When executing the SBO 8.8 PL00  upgrade procedure for databases for an "old" database 2007A PL 42, upgrtade stops whith an error concerning a missing stored procedure "_TmSp_CorrectWrongDocLineNumberInOINMForIPF which is not found"[More]

How Do I Make Updated Procedure in the Program Unit of the Form to Work?

Category:DefaultRelease time:-0001-11-30Views:130

I have updated a procedure in the Program Unit of the Form that I modified. I am not sure what are the proper ways to compile or load the changed procedure in my form to make sure the changes work. Please help me with the following questions: Do I ha[More]

Data is not updated in the database

Category:DefaultRelease time:2015-10-11Views:130

hi.. to all.. i'm using the following code ...... but the data is not updated in the database.. the output window get closed as soon as i clicked save button... i don't know wat's problem with the program... Plz help me.. to get resolve this problem.[More]

How to extract data from oracle database directly in to bi7.0 (net weaver)

Category:DefaultRelease time:2015-10-11Views:130

how to extract data from oracle database directly in to bi7.0 (net weaver)? is it something do with EDI? can anybody explain me in detail? Thanks YorkYou can use UDConnect to get from Oracle database in to BW <b>Data Transfer with UD Connect -</b[More]

Updating values in database table through Transaction

Category:DefaultRelease time:2015-10-11Views:130

Hi, Actually We have one transaction named EWAWA01. In that when we display the values from the transaction, there is a netweight field. The transaction displaying netweight values, but that value is not updated in the database table named EWA_WA_WEI[More]

IPhoto version 9.4.3 update procedure is not responding.

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a problem concerning a normal software update. I have a MacBook Pro runnig OS X 10.8.3 (12D78). Two days ago i got a normal message telling that there is an update available for a new verson of iPhoto (9.4.3) Everything went as normal to t[More]

Getting result set from stored procedures in database controls in weblogic

Category:DefaultRelease time:2015-10-11Views:130

I am calling a stored procedure from database control which actually returns a result set when i call the stored procedure like * @jc:sql statement="call PROC4()" ResultSet sampleProc() throws SQLException; it gives me exception saying "web[More]

Hot
Hello, I have a very interesting problem Exchange 2013 installation step on Hyper-V. I have 2 server. I installed on server Server 2012 R2 Standart. And then installed hyper-v role for both server. I created virtual machine for first server and this [More]
Hey all. Please help. My son, and his wife have an iPhone 4 each. But share one iMac. Right now, my son's mobile me account is sync'd to his iPhone. How does he set it up so she can send and receive her own email under his mobile me? I don't think co [More]
Hi everyone. Tonight I finally got around to attempting to install Leopard. I did backup. I verified/repaired permissions. I did everything I thought I needed to do. I put the 105 disk in, restarted as prompted. On the very first screen, a drop down [More]
My Images won't open in Photoshop CS5 when I click on Edit in Lightroom - even though this option has been selected?  To edit in Photoshop I have to export image from Lightroom then import into Photoshop.  I have other programmes such as NIK and if I [More]
Hey Guys. I've just updated to iTunes 10.5, currently running vista 32bit. I get an error message when i try and start up itunes saying itunes has stopped working, then this... Problem Event Name:          APPCRASH   Application Name:          iTunes [More]
Hello everyone, I need some help on something that Im trying to figure out. I need to plot on a waveform graph different points but I need to change the color by groups of 16. Lets say that I have  304 points and I need to plot it every 16 points wit [More]
I would like to know if anyone knows if it is possible to display a status message which would also create a link such as how the current iTunes track works. This way I could put up a message with a url link. -ThanksHi Alfeo, No. AIM stopped them som [More]
When an Xcode Service bot attempts to perform a build with 'run unit tests' enabled, the build always fails. When looking at the log file the same error repeated many times: xcsbuildd[1966] <Warning>: [XCSBuildOperation.m:106 7368f310 +2126ms] Prefl [More]
HI everyone, I have an experimental data file in ascii format. It contains 10 data sets. I'm trying to read the ascii file and record data in a 2d array for further analysis, but I still could not figure it out how to do it. Please help me to get thi [More]
Hi ! Is there a BADI which gets triggered when the Item Category is being called? I've got the job to filter the level2 of item category based on what has been chosen on level1. Thanks TuHi, You no need to implement any badi for this, just do configu [More]