ORA-00058 DB_BLOCK_SIZE must be string to mount this database (not string)

Error Code

ORA-00058

Description

DB_BLOCK_SIZE must be string to mount this database (not string)

Cause

Possible cause of this error is, DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database.

Action

To solve this error, fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value.

reference

ORA-00057 maximum number of temporary table locks exceeded

Error Code
ORA-00057

Description
maximum number of temporary table locks exceeded

Cause
Possible cause of this error is when number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.

Action
Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.


reference

ORA-00056 DDL lock on object 'string.string' is already held in an incompatible mode

Error Code
ORA-00056 

Description
DDL lock on object 'string.string' is already held in an incompatible mode

Cause
A possible cause of this error is that an attempt was made to acquire a DDL lock that is already locked.

Action
This happens if you attempt to drop a table that has parse locks on it.


reference

Consume ASMX web Service in ASP.NET 4.0

In last tutorial, we learn How to Create ASMX web Service in ASP.NET 4.0. This tutorial guides how to consume it.

• Add new aspx page. Right click on Website and click 'Add New Item'. A new window will appear.

• Select 'Web Form' and name it according to your choice.

• Create new object of web service by writing following code:

MyFirstWebService svc = new MyFirstWebService();

• Call web service method by writing following code:

svc.CallmyName("Waqas Ali");

How to Create ASMX web Service in ASP.NET 4.0

Asmx Web Services are easy and simple to Create and use. This tutorial guides you how to write a ASMX Web Service step by step. 

• Open Visual studio and create new Website. 
• Right Click on Website and Click on 'Add New Item'.

• A New Window will Open, select 'Web Service' , name it and click 'Add'.

• When you click 'Add' Button, new files ( with .asmx and .cs extensions ) will be added to Project.
• Visual Studio will add some code in it.
• A default Web Method named 'Helloworld' will also be added in it.

• You have created ASMX Web Service Successfully.
• Replace 'Helloworld' Web Method with following code.

• This is Custom Web Method we created for our ASMX Web Service.

In next tutorial, we will learn how to use this Web Service.