Assuming procedure is required, the following 17 results were found.
-
our questions but did lead us to a workaround. So this is regarding an error when trying to add parameters to a Stored Procedure of an Oracle database from within Microsoft SQL Server Reporting Services. The Error ORA-00911: invalid character ORA-06512:...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure which Updates a timestamp in an existing table Inserts a row into an audit table I need the report to run the stored...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting Services (SSRS). Well "non-productive" more than "fun" as most of the examples...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Oracle Function Structure. For a more advanced version which uses cursors to work with SSRS, see my article Oracle Stored Procedures in SSRS. What? I asked someone for a simple, easy and basic Oracle stored procedure as my MySQL and T-SQL stored...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
We have a stored procedure which contains two select queries. The first query will retrieve a student ID number where the input parameter is the student's username. The second query will return data using the student ID number found in the first query....
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How? IF OBJECT_ID('usp_ListDistinctValuesAndCounts', 'P') IS NOT NULL...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can be reduced to just a script as long as you declare and set the parameters after the BEGIN and extract the script from...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
- Sorna Kumar IF OBJECT_ID('usp_SearchDB','P') IS NOT NULL DROP PROCEDURE usp_SearchDB GO CREATE PROCEDURE usp_SearchDB @Tablenames VARCHAR(500) ,@SearchStr NVARCHAR(60) ,@GenerateSQLOnly Bit = 0 AS /* Parameters and usage @Tablenames -- Provide a...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html
examples, I'm checking under the [Common] schema, this might be [dbo] for you or a more specific one. -- drop a stored procedure if it exists IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL DROP PROCEDURE...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
which outputs a huge SQL query which you then copy & paste and run against your database. Step 1 of 2 The following stored procedure will generate the full query to your output panel: CREATE PROCEDURE [usp_GenerateSearchbySoundexQuery] ( @p_SearchString...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
The variable name '@GroupName' has already been declared. Variable names must be unique within a query batch or stored procedure. The Quick Fix Return to the Design interface of Report Builder 2.0 for the problematic report: Right-click on the reported...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
document - the spec) Details on the Development Environment (is there a TEST system and deployment procedure in place?) Known Issues/Bugs (is there an "Issues Log"? Anything that still needs addressing?) System Requirements (in case you need to...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
ensuring you use the same Message Group as the DOR. In our example, our Type is "SQL db connector" and we use a stored procedure that the supplier helped setup along with the XML that will be sent to our database table. Be sure to use the same XET code...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
DBMS Random Referencehttps://joellipman.com/articles/database/pl-sql/dbms-random-reference.html
How to use the randomization features of Oracle PL/SQL. Why? I've been tasked with writing a stored procedure that scrambles data for developers working with some of our databases containing sensitive data. How? SELECT DBMS_RANDOM.option1[(option2)]...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF